Date: Wed, 1 Dec 2004 14:23:27 -0800 From: Darcy Buskermolen <darcy@wavefire.com> To: freebsd-performance@freebsd.org Cc: Claus Guttesen <cguttesen@yahoo.dk> Subject: Re: postgresql on FreeBSD 5.3 and high load Message-ID: <200412011423.27424.darcy@wavefire.com> In-Reply-To: <6174636A-43BC-11D9-ACAF-000A95C705DC@chittenden.org> References: <20041201105113.79348.qmail@web14102.mail.yahoo.com> <6174636A-43BC-11D9-ACAF-000A95C705DC@chittenden.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On December 1, 2004 09:13 am, Sean Chittenden wrote: > > Our postgresql-server hits the wall when we get many > > hits on our web. The load-average reaches 70. It > > serves 11 webservers. > > Have you looked to see if you're using spin locks or not? Search for > "amd64 x86_64 spin lock" in PostgreSQL's archives. I think spin locks > were disabled for amd64. When you're at a load of 70, look in > pg_catalog.pg_locks to see if you have any ungranted locks. > > Also, is your application primarily read? You may want to investigate > using pgpool as a way of reducing the overhead for connection startup. > > Another option is to use memcached and remove some queries from the > database all together. -sc Umm I'm not sure where the misscommunication is (it could be at my end), but if I'm not mistalen a DELL 2850 is a dual Xeon EM64T box so all of the amd64 stuff is moot on this platform. -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200412011423.27424.darcy>