Re: Shared buffers vs large files - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Shared buffers vs large files
Date
Msg-id 20020308125008.O25992-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Shared buffers vs large files  ("Glen Parker" <glenebob@nwlink.com>)
Responses Re: Shared buffers vs large files  ("Glen Parker" <glenebob@nwlink.com>)
List pgsql-general
On Fri, 1 Mar 2002, Glen Parker wrote:

> > shared_buffers at 4096 (32MB if my calculations are correct),
> > sort_mem = 65536             # min 32
> > vacuum_mem = 16384          # min 1024
> >
> > The machine has 1GB of ram.
> >
> > I don't expect to have more than a handfull of connections at a time (from
> > 1 to 10). Should I increate the shared buffers to 64MB? 128MB?
>
> On a 1GB machine (still PG 7.1.3) I'm currently running:
>
> shared_buffers: 48000 (about 400MB)
> sort_mem: 8192


What OS are you running this on?
What were your sysv memory settings?


pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: scaling a database
Next
From: Jeff Anto
Date:
Subject: a strange output from vacuum