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

From: Mark Kirkwood
Subject: Re: Bloat issue on 8.3; autovac ignores HOT page splits?
Date: ,
Msg-id: 4D3F40BD.4040504@catalyst.net.nz
(view: Whole thread, Raw)
In response to: Re: Bloat issue on 8.3; autovac ignores HOT page splits?  (Josh Berkus)
Responses: Re: Bloat issue on 8.3; autovac ignores HOT new pages?  (Josh Berkus)
List: pgsql-performance

Tree view

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 by date:

From: Bruce Momjian
Date:
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences
From: Ivan Voras
Date:
Subject: Re: Queries becoming slow under heavy load