Too many messages from Autovacuum - Mailing list pgsql-patches

From Simon Riggs
Subject Too many messages from Autovacuum
Date
Msg-id 1159286666.2696.27.camel@holly
Whole thread Raw
Responses Re: Too many messages from Autovacuum
Re: Too many messages from Autovacuum
List pgsql-patches
Recommending downgrade of these annoying messages from LOG to DEBUG1:

2006-09-23 15:57:56 EDT_3147 LOG:  transaction ID wrap limit is 2147484170, limited by database "postgres"
2006-09-23 15:57:57 EDT_3147 LOG:  transaction ID wrap limit is 2147484170, limited by database "postgres"
2006-09-23 15:59:59 EDT_3394 LOG:  transaction ID wrap limit is 2147484170, limited by database "postgres"
2006-09-23 15:59:59 EDT_3394 LOG:  transaction ID wrap limit is 2147484170, limited by database "postgres"
2006-09-23 16:02:04 EDT_3646 LOG:  transaction ID wrap limit is 2147484170, limited by database "postgres"
2006-09-23 16:04:07 EDT_3892 LOG:  transaction ID wrap limit is 2147484170, limited by database "postgres"
2006-09-23 16:04:08 EDT_3892 LOG:  transaction ID wrap limit is 2147484170, limited by database "postgres"
2006-09-23 16:06:11 EDT_4138 LOG:  transaction ID wrap limit is 2147484170, limited by database "postgres"

No server settings seem appropriate to remove these...

So, patch enclosed to change LOG -> DEBUG1

Other suggestions welcome...

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com

Attachment

pgsql-patches by date:

Previous
From: Jeremy Drake
Date:
Subject: Re: [HACKERS] large object regression tests
Next
From: Tom Lane
Date:
Subject: Re: Too many messages from Autovacuum