Search Postgresql Archives

Re: [Fwd: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum]

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

 




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


[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