Re: shared buffers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: shared buffers
Дата
Msg-id 28074.1098738529@sss.pgh.pa.us
обсуждение исходный текст
Ответ на shared buffers  (Glenn Sullivan <glenn.sullivan@varianinc.com>)
Список pgsql-general
Glenn Sullivan <glenn.sullivan@varianinc.com> writes:
> What is the performance issue with setting shared_buffers to something like 45?
> In doing some timing on my system, I cannot tell any difference with 45 versus 1000.

What are you timing exactly?  Almost every benchmark I've ever seen is
much happier with shared_buffers of at least a few hundred.  Otherwise
you spend too much time copying data between kernel and user space.

            regards, tom lane

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

Предыдущее
От: Együd Csaba
Дата:
Сообщение: Error restoring bytea from dump
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: (S)RPMs for PostgreSQL 7.2.6, 7.3.8 and 7.4.6 are ready