Re: Too frequent warnings for wraparound failure - Mailing list pgsql-admin

From Tom Lane
Subject Re: Too frequent warnings for wraparound failure
Date
Msg-id 3233.1110559211@sss.pgh.pa.us
Whole thread Raw
In response to Re: Too frequent warnings for wraparound failure  ("Milen A. Radev" <milen@securax.org>)
List pgsql-admin
"Milen A. Radev" <milen@securax.org> writes:
> Tom Lane wrote:
>> So you managed to execute about 6000 transactions in those two seconds.
>> Doing what?

> Well that could be the problem - I'm 99.99% positive we do not execute
> so many transactions - may be 30-40 thousand per day and that's only for
> one relatively busy DB. The example database ("xxx1") you've chosen is
> not used at all. As most of the other databases in that cluster.

It doesn't matter --- all the age counts are going up at exactly the
same rate.  Somewhere you've got a client that's issuing dummy
transaction starts at an insane rate.  Some attention to "top" output
on the server might help identify it ;-)

            regards, tom lane

pgsql-admin by date:

Previous
From: John DeSoi
Date:
Subject: Re: Restoring a Dump with psql on Windows Fails - Password Cannot Be Entered (?)
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] PostgreSQL pam ldap document