Re: [HACKERS] Autovacuum loose ends - Mailing list pgsql-patches

From Tom Lane
Subject Re: [HACKERS] Autovacuum loose ends
Date
Msg-id 2444.1122905039@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Autovacuum loose ends  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-patches
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
>>> - Xid-wraparound VACUUM is now FULL without ANALYZE
>>
>> Am I right in my assumption that this VACUUM FULL can happen for any
>> database, not just a template database?

> Ah, right.  I think it would be OK if we made it FULL only for
> datallowcon=false databases.  OTOH maybe it's not worth at all making
> the distinction and we should continue using the previous policy of
> issuing only non-FULL VACUUM.

Strikes me as a waste of cycles: the one database *least* likely to be
in need of a VACUUM FULL is template0.

What we perhaps should consider is VACUUM FREEZE, not FULL, when hitting
a template database --- this would maximize the interval before needing
to do it again.

            regards, tom lane

pgsql-patches by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [HACKERS] For review: Server instrumentation patch
Next
From: Andreas Pflug
Date:
Subject: Re: [HACKERS] For review: Server instrumentation patch