shared_buffers documentation

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: shared_buffers documentation
Date: 2010-04-14 15:05:27
Message-ID: x2w603c8f071004140805xc38061a0w70a8a6f972e17c35@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

TFM says:

Sets the amount of memory the database server uses for shared memory
buffers. The default is typically 32 megabytes (32MB), but might be
less if your kernel settings will not support it (as determined during
initdb). This setting must be at least 128 kilobytes. (Non-default
values of BLCKSZ change the minimum.) However, settings significantly
higher than the minimum are usually needed for good performance.
Several tens of megabytes are recommended for production
installations.

So if the default is 32MB, and what I'm actually supposed to have is
"several tens of megabytes", isn't that pretty much the same thing? I
think this advice is badly outdated. s/tens/hundreds/ might be a good
idea at a minimum, but I'm thinking we might want to also mention the
one-quarter-of-system-memory heuristic.

...Robert

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2010-04-14 15:15:14 Re: shared_buffers documentation
Previous Message Tom Lane 2010-04-14 14:49:36 Re: BUG #5412: test case produced, possible race condition.