| From: | Marti <marti(at)juffo(dot)org> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Gentoo shared_buffers setting (was: BUG #3888: postmaster...) |
| Date: | 2008-01-20 20:07:09 |
| Message-ID: | 54b33ccd0801201207o78e554bbtac9985df9e54af51@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 1/20/08, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-01-20 20:14:49 | Re: Gentoo shared_buffers setting (was: BUG #3888: postmaster...) |
| Previous Message | Tom Lane | 2008-01-20 19:23:52 | psql's \h listing of commands doesn't look nice anymore |