bug? VACUUM ANALYZE {table} outputs transaction id wrap limit to logfile

From: <me(at)alternize(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: bug? VACUUM ANALYZE {table} outputs transaction id wrap limit to logfile
Date: 2006-10-22 05:10:25
Message-ID: 04e401c6f598$62a3e4a0$0201a8c0@iwing
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

when issuing a "VACUUM ANALYZE {tablename}", the currently transaction wrap id is put into the logfile.

2006-10-22 07:04:50 LOG: transaction ID wrap limit is 2147484172, limited by database "postgres"
2006-10-22 07:04:56 LOG: transaction ID wrap limit is 2147484172, limited by database "postgres"
2006-10-22 07:05:02 LOG: transaction ID wrap limit is 2147484172, limited by database "postgres"
2006-10-22 07:05:14 LOG: transaction ID wrap limit is 2147484172, limited by database "postgres"

this can become annoying when one uses ANALYZE every few seconds for heavily changing tables (session-tables) - the messages pile up in the server's logfiles.

i don't recall seen this behaviour in versions prior to 8.2b1

is this intended, and if yes, can it be turned off?

- thomas

Browse pgsql-bugs by date

  From Date Subject
Next Message Yang Zhang 2006-10-22 22:54:49 BUG #2711: PGUSER affects "pg_ctl -w start" behavior
Previous Message Tom Lane 2006-10-21 20:12:27 Re: BUG #2701: PQserverVersion function missing