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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Bloat issue on 8.3; autovac ignores HOT new pages?
Date: 2011-01-31 21:57:00
Message-ID: AANLkTikw9e8-DwL8vVX=yOLOUiO5E4vjCkk4HhhXU-Lt@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Jan 31, 2011 at 11:27 AM, Josh Berkus <josh(at)agliodbs(dot)com> 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.

I used to try and size free space map to be a little bigger than it
needed to be. I now size 4 or 5 times what it needs to be. shared
memory is cheap. So is going to 8.4, but on legacy systems that you
can't upgrade, 8.3 with a huge FSM works well enough (with suitably
aggressive autovac).

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Lew 2011-01-31 23:41:26 Re: Any experience using "shake" defragmenter?
Previous Message Mark Kirkwood 2011-01-31 21:23:02 Re: Bloat issue on 8.3; autovac ignores HOT new pages?