Re: Slow updates, poor IO

Поиск
Список
Период
Сортировка
От John Huttley
Тема Re: Slow updates, poor IO
Дата
Msg-id 48DFFCDB.3020000@mib-infotech.co.nz
обсуждение исходный текст
Ответ на Re: Slow updates, poor IO  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Slow updates, poor IO  (John Huttley <John@mib-infotech.co.nz>)
Список pgsql-performance
Ahh! I've not dealt with that before. I'll look it up.
Thanks Tom.


Tom Lane wrote:
John Huttley <John@mib-infotech.co.nz> writes: 

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 по дате отправления:

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