Martin Nickel wrote:
> On Tue, 18 Oct 2005 08:52:15 +0100, Richard Huxton wrote:
> >   3. Actually - are you happy that your general configuration is OK? 
> We're running dual Opteron 244s with 4G of memory.  The platform is
> Suse 9.3, 64 bit.  The database is on a 3ware 9500S-8 sata raid controller
> configured raid 10 with 4 drives plus a hot swap.  Drives are
> 7400 rpm (don't remember model or size).
> I'm running Postgres 8.0.3.  Here are some of the relevant conf file
> parameters:
> shared_buffers = 50000
> sort_mem = 8192
> work_mem = 256000

Interesting that you set both sort_mem and work_mem.  Do you realize
that the former is an obsolete name, and currently a synonym for the
latter?  Maybe the problem is that you are using too much memory for
sorts, forcing swap usage, etc.

Alvaro Herrera       
"La persona que no querĂ­a pecar / estaba obligada a sentarse
 en duras y empinadas sillas    / desprovistas, por cierto
 de blandos atenuantes"                          (Patricio Vogel)

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


Reply via email to