Postgres Pro
Downloads
Home   >   mailing lists

Re: Shared_buffers and kernel parameters, tuning - Mailing list pgsql-admin

From Tom Lane
Subject Re: Shared_buffers and kernel parameters, tuning
Date
Msg-id 27128.1054912523@sss.pgh.pa.us
Whole thread Raw
In response to Shared_buffers and kernel parameters, tuning  ("Lending, Rune" <rune.lending@inpoc.com>)
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: Marco Aurélio Cerqueira Teixeira
Date:
Subject: Doubt about Database Migration Wizard
Next
From: Robert Treat
Date:
Subject: Re: No acceptable C compiler found