Thanks guys.
I think I've got a clearer idea of what's going on here. Basically I
need to take more into account than just the shared buffers setting,
and knowing that, I can leave extra head-room for other options which
will likely take up shared memory.
Cheers
Thom
On Wed, Nov 12, 2008 at 1:
On Tue, 11 Nov 2008, Thom Brown wrote:
I've noticed that if I set my SHMMAX to 256 * 1024 * 1024 (268435456)
and my shared_buffers value in postgresql.conf to 256MB the server
fails to start. I managed to find a tipping point: 249MB seems to be
too much and 248MB seems to be okay.
Buffers are
Sam Mason <[EMAIL PROTECTED]> writes:
> On Tue, Nov 11, 2008 at 02:17:20PM -0300, Alvaro Herrera wrote:
>> shared_buffers is not the only factor to shared memory, so you need to
>> provide some extra SHMMAX slop.
> what is this "extra slop" needed for?
See table 17-2 here
http://www.postgresql.or
Scott Marlowe escribió:
> On Tue, Nov 11, 2008 at 10:58 AM, Sam Mason <[EMAIL PROTECTED]> wrote:
> > what is this "extra slop" needed for?
> free space map and temp buffers. Not sure what else.
Lock space, pg_clog, pg_subtrans and pg_multixact buffers, FSM, and some
other things. External modu
On Tue, Nov 11, 2008 at 10:58 AM, Sam Mason <[EMAIL PROTECTED]> wrote:
> On Tue, Nov 11, 2008 at 02:17:20PM -0300, Alvaro Herrera wrote:
>> Thom Brown escribió:
>> > I've noticed that if I set my SHMMAX to 256 * 1024 * 1024 (268435456)
>> > and my shared_buffers value in postgresql.conf to 256MB th
On Tue, Nov 11, 2008 at 02:17:20PM -0300, Alvaro Herrera wrote:
> Thom Brown escribió:
> > I've noticed that if I set my SHMMAX to 256 * 1024 * 1024 (268435456)
> > and my shared_buffers value in postgresql.conf to 256MB the server
> > fails to start. I managed to find a tipping point: 249MB seems
Thom Brown escribió:
> Hi,
>
> I've noticed that if I set my SHMMAX to 256 * 1024 * 1024 (268435456)
> and my shared_buffers value in postgresql.conf to 256MB the server
> fails to start. I managed to find a tipping point: 249MB seems to be
> too much and 248MB seems to be okay.
>
> Could someon
Actually, I think I may have solved it, but I would like someone to verify it.
The temp_buffers takes up 8MB which suggests that needs to be taken
into account, so 256MB - 8MB = 248MB.
Is this right?
Thanks
Thom
On Tue, Nov 11, 2008 at 4:57 PM, Thom Brown <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I
