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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match