Re: Slow updates, poor IO

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Slow updates, poor IO
Дата
Msg-id 6110.1222612388@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Slow updates, poor IO  (John Huttley <John@mib-infotech.co.nz>)
Ответы Re: Slow updates, poor IO  ("Scott Carey" <scott@richrelevance.com>)
Re: Slow updates, poor IO  (John Huttley <John@mib-infotech.co.nz>)
Список pgsql-performance
John Huttley <John@mib-infotech.co.nz> writes:
> Scott Marlowe wrote:
>> was...  was a part of the trade-offs.

> You are thinking of HOT?
> I don't think it applies in the case of full table updates??

Sure, as long as there's enough free space on each page.

If you wanted to make a table that was optimized for this kind of thing,
you could try creating it with fillfactor 50.

            regards, tom lane

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

Предыдущее
От: John Huttley
Дата:
Сообщение: Re: Slow updates, poor IO
Следующее
От: "Scott Carey"
Дата:
Сообщение: Re: Slow updates, poor IO