Re: Shared buffers vs large files

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Glen Parker <glenebob(at)nwlink(dot)com>
Cc: Pg-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Shared buffers vs large files
Date: 2002-03-08 17:53:47
Message-ID: 20020308125008.O25992-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Anto 2002-03-08 18:15:14 a strange output from vacuum
Previous Message Francisco Reyes 2002-03-08 17:47:37 Re: scaling a database