postgresql on FreeBSD 5.3 and high load

[Simon L. Nielsen]

On 2004.12.01 14:23:27 -0800, Darcy Buskermolen wrote:
> 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.

EM64T is Intel's name for amd64 (with a few minor differences AFAIR),
since it would be kind of embarrassing for Intel to really admit they
had to copy AMD :-).

-- 
Simon L. Nielsen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-performance/attachments/20041201/f2310024/attachment.bin