John R Pierce <pie...@hogranch.com> writes: > On 12/4/2017 2:21 PM, chris kim wrote: >> How would I investigate if my database is nearing a transaction wrap >> around.
> it would be screaming bloody murder in the log, for one.
I think the simplest thing is to keep an eye on
select max(age(datfrozenxid)) from pg_database;
If that starts to approach two billion, or gets a lot larger than
autovacuum_freeze_max_age, you've got a problem.
regards, tom lane
