Re: FreeBSD & Shared Memory - Mailing list pgsql-admin

From Tom Lane
Subject Re: FreeBSD & Shared Memory
Date
Msg-id 26418.1087061153@sss.pgh.pa.us
Whole thread Raw
In response to FreeBSD & Shared Memory  (Michael Fork <mfork00@yahoo.com>)
List pgsql-admin
Michael Fork <mfork00@yahoo.com> writes:
> Here is the output of sysctl (which shows there is
> more shared mem available than postgres is asking for):

> bash-2.05b$ sysctl -a | grep shm
> kern.ipc.shmmax: 200000000
> kern.ipc.shmmin: 1
> kern.ipc.shmmni: 192
> kern.ipc.shmseg: 128
> kern.ipc.shmall: 8192
> kern.ipc.shm_use_phys: 0

I forget exactly what units shmall is measured in, but I'm pretty sure
that 8192 isn't enough to allow 100MB of shared memory.

            regards, tom lane

pgsql-admin by date:

Previous
From: Michael Fork
Date:
Subject: FreeBSD & Shared Memory
Next
From: pginfo
Date:
Subject: problem with pg_dump