Re: shared_buffers advice

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: shared_buffers advice
Дата
Msg-id 15895.1268778326@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: shared_buffers advice  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: shared_buffers advice  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Tom Lane escribió:
>> That's not going to do anything towards reducing the actual I/O volume.
>> Although I suppose it might be useful if it just cuts the number of
>> seeks.

> Oh, they had no problems with I/O volume.  It was relation extension
> lock that was heavily contended for them.

Really?  I guess that serialized all the I/O ... I'll bet if we got rid
of that locking somehow, they *would* have a problem with I/O volume.

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: shared_buffers advice
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: shared_buffers advice