Re: is pg_autovacuum so effective ?

Hi, Gaetano,

Gaetano Mendola schrieb:

> I have the same requirement too. Actually pg_autovacuum can not be
> instructed "per table" so some time the global settings are not good
> enough. I have a table of logs with 6 milions rows ( 3 years logs )
> I insert on that page ~ 6000 rows for day. I'm running pg_autovacuum
> with setting to ANALYZE or VACUUM table if the 10% is touched.
> With this setting pg_autovacuum will analyze that table each 3 months!!!

If you have only inserts, and only so few on a large table, you do not
need to vacuum such often. Not to reclaim space, only to prevent
transaction ID wraparound (which is ensured by pg_autovacuum).

And if the data distribution does not change, frequently calling ANALYZE
does not help much, either.

Markus

--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios(at)logi-track(dot)com | www.logi-track.com