Re: Bloat issue on 8.3; autovac ignores HOT page splits?

От: Mark Kirkwood
Тема: Re: Bloat issue on 8.3; autovac ignores HOT page splits?
Дата: ,
Msg-id: 4D3F40BD.4040504@catalyst.net.nz
(см: обсуждение, исходный текст)
Ответ на: Re: Bloat issue on 8.3; autovac ignores HOT page splits?  (Josh Berkus)
Ответы: Re: Bloat issue on 8.3; autovac ignores HOT new pages?  (Josh Berkus)
Список: pgsql-performance

Скрыть дерево обсуждения

Bloat issue on 8.3; autovac ignores HOT page splits?  (Josh Berkus, )
 Re: Bloat issue on 8.3; autovac ignores HOT page splits?  (Robert Haas, )
  Re: Bloat issue on 8.3; autovac ignores HOT page splits?  (Josh Berkus, )
   Re: Bloat issue on 8.3; autovac ignores HOT page splits?  (Mark Kirkwood, )
    Re: Bloat issue on 8.3; autovac ignores HOT new pages?  (Josh Berkus, )
     Re: Bloat issue on 8.3; autovac ignores HOT new pages?  (Mark Kirkwood, )
     Re: Bloat issue on 8.3; autovac ignores HOT new pages?  (Scott Marlowe, )
      Re: Bloat issue on 8.3; autovac ignores HOT new pages?  (Mark Kirkwood, )

On 26/01/11 07:28, Josh Berkus wrote:
>
> One question: in 8.3 and earlier, is the FSM used to track dead_rows for
> pg_stat_user_tables?
>

If I'm understanding you correctly, ANALYZE is the main guy
tracking/updating the dead row count.

regards

Mark


В списке pgsql-performance по дате сообщения:

От: Bruce Momjian
Дата:
Сообщение: Re: Running PostgreSQL as fast as possible no matter the consequences
От: Ivan Voras
Дата:
Сообщение: Re: Queries becoming slow under heavy load