stats_start_collector = on #stats_command_string = off #stats_block_level = off stats_row_level = on Yes...it is on. I have other databases with similar data flow. Havent encountered this issue yet (although I have to watch and vacuum manually to prevent such errors) Which option in the config file should I tweak to see autovacuum logging entries? Thanks Sriram -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Wednesday, September 06, 2006 3:11 PM To: Sriram Dandapani Cc: Scott Marlowe; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] transactoin id wraparound problem "Sriram Dandapani" <sdandapani@xxxxxxxxxxxxxxx> writes: > Curious why autovacuum does not handle this problem. Here are my > settings > autovacuum = on # enable autovacuum Do you have stats_row_level enabled? If not, autovac doesn't work. regards, tom lane
