Excerpts from Tom Lane's message of mar jun 26 18:58:45 -0400 2012:
> Even if you actively try to configure the shmem settings to exactly
> fill shmmax (which I concede some installation scripts might do),
> it's going to be hard to do because of the 8K granularity of the main
> knob, shared_buffers.
Actually it's very easy -- just try to start postmaster on a system with
not enough shmmax and it will tell you how much shmem it wants. Then
copy that number verbatim in the config file. This might fail on picky
systems such as MacOSX that require some exact multiple or power of some
other parameter, but it works fine on Linux.
I think the minimum you can request, at least on Linux, is 1 byte.
> Moreover, a installation script that did that
> would soon learn not to, because of the fact that we don't worry too
> much about changing small details of shared memory consumption in minor
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-hackers by date
|Next:||From: Andres Freund||Date: 2012-06-26 23:26:00|
|Subject: embedded list v2|
|Previous:||From: Nils Goroll||Date: 2012-06-26 22:58:47|
|Subject: experimental: replace s_lock spinlock code with pthread_mutex on