FYI, the restriction that -B must be larger than -N will be removed in 8.4.
---
Andreas Kling wrote:
> Greetings,
>
> Starting PostgreSQL 8.3.0 with the default options used by Gentoo Linux
> (-N 40 -B 80) causes it to bai
I wrote:
> Anyway, it seems that we cannot raise the minimum value of
> shared_buffers to 200, or even 100, unless we are prepared to blow off
> SHMMAX = 2MB or do something about the fixed SLRU allocation.
After further thought I propose that we just eliminate the interlock
between -N and -B. I
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> I think at the time we set the current minimum -B we were still
>> intending that you could run in a half meg or so SHMMAX allocation.
>> That's certainly history. Maybe we should target 2 meg as the rock
>> bottom minimum?
> That
Tom Lane wrote:
> I think at the time we set the current minimum -B we were still
> intending that you could run in a half meg or so SHMMAX allocation.
> That's certainly history. Maybe we should target 2 meg as the rock
> bottom minimum?
That makes sense to me. It corresponds to 128 connections
Magnus Hagander <[EMAIL PROTECTED]> writes:
> Those are not comments on the actual patch, of course. For that one, it
> looks to me like it's the wrong fix. I don't think we should be adding
> to shared buffers like that - if somebody asked for a specific value
> they should get that.
Agreed, t
Andreas Kling wrote:
Magnus Hagander wrote:
Anybody know *why* Gentoo does such a thing? Having shared buffers at
the very lowest possible boundary just seems counterproductive. Plus,
the normal way to set these things would be in postgresql.conf, why
override them on the commandline?
It's
Magnus Hagander wrote:
Anybody know *why* Gentoo does such a thing? Having shared buffers at
the very lowest possible boundary just seems counterproductive. Plus,
the normal way to set these things would be in postgresql.conf, why
override them on the commandline?
It's not the first time I'v
Andreas Kling wrote:
Greetings,
Starting PostgreSQL 8.3.0 with the default options used by Gentoo Linux
(-N 40 -B 80) causes it to bail with an error message.
"the number of buffers (-B) must be at least twice the number of allowed
connections (-N) and at least 16"
The problem is that NBuf
Greetings,
Starting PostgreSQL 8.3.0 with the default options used by Gentoo Linux
(-N 40 -B 80) causes it to bail with an error message.
"the number of buffers (-B) must be at least twice the number of allowed
connections (-N) and at least 16"
The problem is that NBuffers is actually "max
