John R Pierce <pierce@xxxxxxxxxxxx> 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
