I have gotten two reports via IRC that months after using 9.0 pg_upgrade, some of the clog files have been removed while there is still data in the table needing those clog files. These reports came to me through Rhodiumtoad who analyzed the systems.
Looking at pg_upgrade, I am concerned that somehow autovaccum is running in frozen mode before I have restored the frozen xids for the table or database. Here is the code I am using: snprintf(cmd, sizeof(cmd), SYSTEMQUOTE "\"%s/pg_ctl\" -l \"%s\" -D \"%s\" " "-o \"-p %d -c autovacuum=off " "-c autovacuum_freeze_max_age=2000000000\" " "start >> \"%s\" 2>&1" SYSTEMQUOTE, bindir, Does anyone have any other suggestions on how to make sure autovacuum does not run in freeze mode? I know 'autovacuum=off' turns off normal autovacuum. Would increasing autovacuum_naptime help? It looks like the autovacuum code sleeps before processing anything, but I am not certain. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers