Re: 8.2 Autovacuum BUG ?

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Pallav Kalva <pkalva(at)livedatagroup(dot)com> writes:
>     We turned on autovacuums on 8.2 and we have a database which is read 
> only , it is basically a USPS database used only for address lookups 
> (only SELECTS, no updates/deletes/inserts).

>     This database has about 10gig data and yesterday autovacuum started 
> on this database and all of a sudden I see lot of archive logs generated 
> during this time, I guess it might have generated close to 3-4gig data 
> during this period.

Probably represents freezing of old tuples, which is a WAL-logged
operation as of 8.2.  Is it likely that the data is 200M transactions
old?

			regards, tom lane