Re: Shared buffers vs large files

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Shared buffers vs large files
Дата
Msg-id 20020308125008.O25992-100000@zoraida.natserv.net
обсуждение исходный текст
Ответ на Re: Shared buffers vs large files  ("Glen Parker" <glenebob@nwlink.com>)
Ответы Re: Shared buffers vs large files  ("Glen Parker" <glenebob@nwlink.com>)
Список 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 по дате отправления:

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: scaling a database
Следующее
От: Jeff Anto
Дата:
Сообщение: a strange output from vacuum