Re: Docs about buffers and sortmem setting

Поиск
Список
Период
Сортировка
От Bjoern Metzdorf
Тема Re: Docs about buffers and sortmem setting
Дата
Msg-id 00d701c28bd8$28ecce80$0564a8c0@toolteam.net
обсуждение исходный текст
Ответ на Docs about buffers and sortmem setting  (Ryszard Lach <rla@id.pl>)
Ответы Re: Docs about buffers and sortmem setting  (Andrew Sullivan <andrew@libertyrms.info>)
Re: Docs about buffers and sortmem setting  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-performance
> The general rule of thumb is to try about 25% of physical memory for
> your buffer size.  Some people like to increase from there, until
> swapping starts, and then back off; but there are arguments against
> doing this, given the efficiency of modern filesystem buffering.

How about 32-bit Linux machines with more than 1 GB RAM? We have a 2 GB RAM
machine running, and I gave 800 MB to postgres shared buffers. AFAIK Linux
user space can handle only 1 GB and the rest is for kernel buffer and
cache..

Regards,
Bjoern


В списке pgsql-performance по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Docs about buffers and sortmem setting
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Docs about buffers and sortmem setting