Postgres Pro
Downloads
Home   >   mailing lists

Re: Index bloat, reindex weekly, suggestions etc? - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Index bloat, reindex weekly, suggestions etc?
Date
Msg-id dcc563d10810171002j6e5491d4nb46e5dca8159698c@mail.gmail.com
Whole thread Raw
In response to Re: Index bloat, reindex weekly, suggestions etc?  ("Tory M Blue" <tmblue@gmail.com>)
Responses Re: Index bloat, reindex weekly, suggestions etc?
List pgsql-performance
Tree view 
On Fri, Oct 17, 2008 at 10:47 AM, Tory M Blue <tmblue@gmail.com> wrote:
> DETAIL:  A total of 501440 page slots are in use (including overhead).
> 501440 page slots are required to track all free space.
> Current limits are:  1087500 page slots, 430 relations, using 6401 kB.
> VACUUM
>
> that looks fine

That's still a lot of dead space.  You might do better with more
aggresive autovacuuming settings.

pgsql-performance by date:

Previous
From: "Tory M Blue"
Date:
Subject: Re: Index bloat, reindex weekly, suggestions etc?
Next
From: "Tory M Blue"
Date:
Subject: Re: Index bloat, reindex weekly, suggestions etc?