Re: [HACKERS] postmaster failure with 2-23 snapshot - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] postmaster failure with 2-23 snapshot
Date
Msg-id 14302.919870433@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] postmaster failure with 2-23 snapshot  (Brian P Millett <bpm@ec-group.com>)
List pgsql-hackers
Brian P Millett <bpm@ec-group.com> writes:
> BUT I didn't have
> set shmsys:shminfo_shmmax=16777216
> That was it.

I'll bet the default value of SHMMAX on your kernel is 1MB.
You said 6.4.x worked for you, right?

A stock version of 6.4.x creates a shared memory segment of about
830K if you don't alter the default -B setting.  Thanks to some
changes I made recently in the memory space estimation stuff,
the current CVS sources will try to make a shm segment of about
1100K with the default -B and -N settings.

If 1MB is a popular SHMMAX default, it might be a good idea to
trim down the safety margin a little bit so we come out short of
1MB at the default settings ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] VACUUM ANALYZE problem on linux
Next
From: Oleg Broytmann
Date:
Subject: Re: [HACKERS] Problem with complex query