postgresql on FreeBSD 5.3 and high load
darcy at wavefire.com
Wed Dec 1 14:23:29 PST 2004
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.
Wavefire Technologies Corp.
More information about the freebsd-performance