Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-performance by date:

Previous
From: Lew
Date:
Subject: Re: Any experience using "shake" defragmenter?
Next
From: Scott Marlowe
Date:
Subject: Re: Bloat issue on 8.3; autovac ignores HOT new pages?