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:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 3:11 PM To: Sriram Dandapani Cc: Scott Marlowe; [email protected] Subject: Re: [ADMIN] transactoin id wraparound problem "Sriram Dandapani" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
