From: | "Tory M Blue" <tmblue(at)gmail(dot)com> |
---|---|
To: | "Scott Marlowe" <scott(dot)marlowe(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:15:12 |
Message-ID: | 8a547c840810171015x7b330cc0h23f5afa7fc9d3ff5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Fri, Oct 17, 2008 at 10:02 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> 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.
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2008-10-17 17:35:32 | Re: Index bloat, reindex weekly, suggestions etc? |
Previous Message | Scott Marlowe | 2008-10-17 17:02:35 | Re: Index bloat, reindex weekly, suggestions etc? |