Re: Bloat issue on 8.3; autovac ignores HOT new pages?

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: Bloat issue on 8.3; autovac ignores HOT new pages?
Дата
Msg-id 4D472836.9000108@catalyst.net.nz
обсуждение исходный текст
Ответ на Re: Bloat issue on 8.3; autovac ignores HOT new pages?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
On 01/02/11 07:27, Josh Berkus wrote:
Robert, Mark,

I have not been able to reproduce this issue in a clean test on 9.0.  As
a result, I now think that it was related to the FSM being too small on
the user's 8.3 instance, and will consider it resolved.


Right - it might be interesting to see if you can reproduce on 8.4. I would hazard a guess that you will not (on disk FSM + visibility map vacuum improvements seem to make this whole area way better).

Cheers

Mark

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

Предыдущее
От: Lew
Дата:
Сообщение: Re: Any experience using "shake" defragmenter?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Bloat issue on 8.3; autovac ignores HOT new pages?