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
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 |