Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group