Alvaro Herrera wrote:
FYI, in 8.2 and up the Xid wraparound problem is considered on a table
by table basis, which means that only the tables that have not been
vacuumed recently need to be vacuumed. The need for database wide
vacuuming is gone.
That's good.
Time to start VACUUM FULL ANALYZE over the weekend.
For Xid wraparound you don't need FULL anyway, in any release
I realize that I don't need a FULL VACUUM for the xid wraparound, but
since it hasn't been run for a while I'll do a FULL.
Thanks!
Ron