Re: shared buffers

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: shared buffers
Дата
Msg-id 4313BF95.3030105@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: shared buffers  (Carlos Henrique Reimer <carlosreimer@yahoo.com.br>)
Список pgsql-performance
> I forgot to say that it´s a 12GB database...

That's actually not that large.

> Ok, I´ll set shared buffers to 30.000 pages but even so "meminfo" and
> "top" shouldn´t show some shared pages?

Yeah. The reason for not setting buffers so high is because PostgreSQL
cannot efficiently manage huge shared buffers, so you're better off
giving the RAM to Linux's disk cache.

Chris


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

Предыдущее
От: Carlos Henrique Reimer
Дата:
Сообщение: Re: shared buffers
Следующее
От: Tom Lane
Дата:
Сообщение: Re: shared buffers