Postgres Pro
Downloads
Home   >   mailing lists

Re: Bloat issue on 8.3; autovac ignores HOT page splits? - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Bloat issue on 8.3; autovac ignores HOT page splits?
Date
Msg-id 4D3F40BD.4040504@catalyst.net.nz
Whole thread Raw
In response to Re: Bloat issue on 8.3; autovac ignores HOT page splits?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Bloat issue on 8.3; autovac ignores HOT new pages?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Tree view 
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:

Previous
From: Josh Berkus
Date:
Subject: Re: Bloat issue on 8.3; autovac ignores HOT page splits?
Next
From: "Anne Rosset"
Date:
Subject: Queries becoming slow under heavy load