Re: Index bloat, reindex weekly, suggestions etc?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Tory M Blue" <tmblue(at)gmail(dot)com>
Cc: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Index bloat, reindex weekly, suggestions etc?
Date: 2008-10-17 17:02:35
Message-ID: dcc563d10810171002j6e5491d4nb46e5dca8159698c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Oct 17, 2008 at 10:47 AM, Tory M Blue <tmblue(at)gmail(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tory M Blue 2008-10-17 17:15:12 Re: Index bloat, reindex weekly, suggestions etc?
Previous Message Tory M Blue 2008-10-17 16:47:49 Re: Index bloat, reindex weekly, suggestions etc?