It's not in the docs because it has to do with the use you make of your OS. The docs
only mention that shmem is used by Pg so increasing it could benefit you. The rule of
thumb (last week's list archives) is to tell postgres on startup to use shmem
equivalent to approximately 1/4 of you total memory. This is done either through the
-B <value> startup parameter, or by editing the shared_buffers entry in the
$PGDATA/postgres.conf
Keep in mind that each segment is 8192 bytes, so do the math accordingly.
cheers,
thalis
On Mon, 25 Jun 2001, Sanjay Bhatia wrote:
> Hi,
>
> Can someone please tell me how to figure the optimal value of SHMMAX? I
> have not been able to find this information in the docs.
>
> Thanks,
> sb
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
>
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]