Culley Harrelson wrote:
> I will definitely look into this. I suspect I need to tune my kernel
> settings first though...
No, not much. Sysctl and loader.conf settings are enough.
>>> $ cat /etc/sysctl.conf
shmmax is in bytes, so this is 256 MB - way too low.
shmall is in pages, so this is 256 MB also - which is in sync with the
above but will fall apart if some other service needs shm memory.
Set shmall to 2 GB and shmmax to 1.9 GB.
>>> $ cat /boot/loader.conf
I think these are way too low also. I use 10240 and 16384 for semmni and
semmns habitually but these might be overtuned :)
>>> In postgresql.conf I have:
>>> max_connections = 180
>>> shared_buffers = 28MB
Definitely too low and out of sync with the above settings.
Set shared_buffers to around 1800 MB or 1900 MB.
These settings are a good start, but you can find many tutorials and
documents on tuning pgsql if you search around.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2009-08-18 15:05:23|
|Subject: Re: Weird index or sort behaviour |
|Previous:||From: Matthew Wakeling||Date: 2009-08-18 13:20:21|
|Subject: Weird index or sort behaviour|