Re: Shared_buffers and kernel parameters, tuning

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lending, Rune" <rune(dot)lending(at)inpoc(dot)com>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Shared_buffers and kernel parameters, tuning
Date: 2003-06-06 15:15:23
Message-ID: 27128.1054912523@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Lending, Rune" <rune(dot)lending(at)inpoc(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David F. Skoll 2003-06-06 16:19:56 Compiling on HP-UX 11.11
Previous Message Robert Treat 2003-06-06 15:12:17 Re: No acceptable C compiler found