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

From Tory M Blue
Subject Re: Index bloat, reindex weekly, suggestions etc?
Date
Msg-id 8a547c840810171015x7b330cc0h23f5afa7fc9d3ff5@mail.gmail.com
Whole thread Raw
In response to Re: Index bloat, reindex weekly, suggestions etc?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
On Fri, Oct 17, 2008 at 10:02 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> 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.


Hmmm, autovac is on by default and it appears I've left most of the
default settings in play, but since I don't get any fsm warnings,
things seem to be running cleanly.

autovacuum_max_workers = 5              # max number of autovacuum subprocesses

autovacuum_vacuum_threshold = 1000      # min number of row updates before
                                        # vacuum
autovacuum_analyze_threshold = 2000     # min number of row updates before
                                        # analyze

in fact there is a vac running right now :)

Thanks Scott!

Tory

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Index bloat, reindex weekly, suggestions etc?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Index bloat, reindex weekly, suggestions etc?