Search Postgresql Archives

Re: Performance of autovacuum and full vacuum of database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux