Re: Gentoo shared_buffers setting (was: BUG #3888: postmaster...) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Gentoo shared_buffers setting (was: BUG #3888: postmaster...)
Date
Msg-id 11787.1200860089@sss.pgh.pa.us
Whole thread Raw
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: psql's \h listing of commands doesn't look nice anymore
Next
From: Tom Lane
Date:
Subject: Re: psql's \h listing of commands doesn't look nice anymore