Postgres Pro
Downloads
Home   >   mailing lists

Thread: increasing shared buffers

increasing shared buffers

From
Hal Lynch
Date:
I am running Postgresql 7.3.2 on FreeBSD 4.7.

I want to increase the Postgres shared buffers to 8192,
approx. 67M correct?

To do this I need to increase the amount of shared memory
available from the OS.

Does anyone know how to do this on FreeBSD 4.7?

hal

Re: increasing shared buffers

From
Robert Treat
Date:
On Tue, 2003-04-08 at 19:07, Hal Lynch wrote:
> I am running Postgresql 7.3.2 on FreeBSD 4.7.
>
> I want to increase the Postgres shared buffers to 8192,
> approx. 67M correct?
>

If I'm doing the math in my head right, I think it's actually 64MB, but
close enough.

> To do this I need to increase the amount of shared memory
> available from the OS.
>
> Does anyone know how to do this on FreeBSD 4.7?
>

I believe the following link has what your looking for:
http://www.gtsm.com/cgi/psearch?h=1;c=0;j=0;page=kernel-resources.html#SYSVIPC

Robert Treat