Thread: 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 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