"Lending, Rune" <rune.lending@inpoc.com> writes:
> in postgresql.conf:
> shared_buffers = 117248 (shmmax / 2 / 1024 / 8 ) This I got from this forum.
This is a factor of 10, maybe a factor of 100, more than you need.
It's usually better to let the kernel manage memory. See the
pgsql-performance archives (whenever they're back up :-().
regards, tom lane