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

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Bloat issue on 8.3; autovac ignores HOT page splits?
Date: 2011-01-25 21:29:33
Message-ID: 4D3F40BD.4040504@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Anne Rosset 2011-01-25 21:37:54 Queries becoming slow under heavy load
Previous Message Josh Berkus 2011-01-25 18:28:14 Re: Bloat issue on 8.3; autovac ignores HOT page splits?