From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
---|---|
To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
Cc: | Vivek Khera <vivek(at)khera(dot)org>, PG-General General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Performance of autovacuum and full vacuum of database |
Date: | 2005-11-11 16:49:32 |
Message-ID: | 1131727772.8979.82.camel@coppola.muc.ecircle.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
OK, I've found it:
http://www.postgresql.org/docs/8.1/interactive/catalog-pg-autovacuum.html
One more incentive to upgrade as quickly as possible.
Cheers,
Csaba.
On Fri, 2005-11-11 at 17:40, Csaba Nagy wrote:
> [snip]
> > With the release of 8.1 and it's integrated version of autovacuum, you
> > can now set per table settings for for vauum and analyze thresholds,
> > vacuum cost delay, and table enable / disable. This addresses what was
> > probably the largest deficiency with the old contrib version.
>
> Cool ! I didn't know that... I just wanted to volunteer to implement
> that :-D
>
> But I can't see where can you set the per table settings ? In the config
> file I didn't find any reference to this...
>
> Cheers,
> Csaba.
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Veatch | 2005-11-11 16:58:22 | Re: A good postgresql book |
Previous Message | Csaba Nagy | 2005-11-11 16:40:58 | Re: Performance of autovacuum and full vacuum of database |