Gentoo shared_buffers setting (was: BUG #3888: postmaster...)
On 1/20/08, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Marti Raudsepp wrote:
However, as of PostgreSQL 8.3, postmaster requires that the number of
buffers is at least (max_connections*2 + 6)
It's sort of irrelevant IMHO, as any useful setting is orders of
magnitude larger than that anyway.
Gentoo defaults to launching PostgreSQL 8.2 with "-N 40 -B 80" which
is how I hit this problem; this was set in a distro-specific
configuration file which I previously hadn't even looked at. Does this
mean that these defaults are insane and I should complain loudly?
Regards,
Marti Raudsepp
Marti <marti@juffo.org> writes:
On 1/20/08, Tom Lane <tgl@sss.pgh.pa.us> wrote:
It's sort of irrelevant IMHO, as any useful setting is orders of
magnitude larger than that anyway.
Gentoo defaults to launching PostgreSQL 8.2 with "-N 40 -B 80" which
is how I hit this problem; this was set in a distro-specific
configuration file which I previously hadn't even looked at. Does this
mean that these defaults are insane and I should complain loudly?
Egad. Yes. Quite aside from whether the specific values are sane,
the launch script has utterly no business setting any such parameters
on the postmaster command line anyway --- it should be leaving them to
the configuration file. (initdb will normally put values that are at
least minimally sane into the config file. What do you see for
max_connections and shared_buffers in postgresql.conf?)
regards, tom lane
Marti wrote:
Gentoo defaults to launching PostgreSQL 8.2 with "-N 40 -B 80" which
is how I hit this problem; this was set in a distro-specific
configuration file which I previously hadn't even looked at. Does this
mean that these defaults are insane and I should complain loudly?
Why waste time complaining? Jump ship before you drown. Are there some
boats left?
FWIW the Gentoo packaging of Postgres has historically been more broken
than I care to remember. We reported a couple of serious bugs and due
to a complete silence as response I stopped wasting my with it.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support