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 15917.1110474897@sss.pgh.pa.us
Whole thread Raw
In response to Re: Too frequent warnings for wraparound failure  ("Milen A. Radev" <milen@securax.org>)
Responses Re: Too frequent warnings for wraparound failure  ("Milen A. Radev" <milen@securax.org>)
List pgsql-admin
"Milen A. Radev" <milen@securax.org> writes:
> Two queries - 2 seconds apart:

> template1=# SELECT datname, age(datfrozenxid) FROM pg_database;
>   datname  |     age
> - -----------+-------------
>  xxx1      |  1519763573

> template1=# SELECT datname, age(datfrozenxid) FROM pg_database;
>   datname  |     age
> - -----------+-------------
>  xxx1      |  1519769620

So you managed to execute about 6000 transactions in those two seconds.
Doing what?

            regards, tom lane

pgsql-admin by date:

Previous
From: Hemapriya
Date:
Subject: Grant ALL on schema
Next
From: Gaurav Arora
Date:
Subject: another admin ?