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

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Bloat issue on 8.3; autovac ignores HOT new pages?
Date: 2011-01-31 21:23:02
Message-ID: 4D472836.9000108@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2011-01-31 21:57:00 Re: Bloat issue on 8.3; autovac ignores HOT new pages?
Previous Message Josh Berkus 2011-01-31 18:27:33 Re: Bloat issue on 8.3; autovac ignores HOT new pages?