postgresql on FreeBSD 5.3 and high load

[Darcy Buskermolen]

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