Re: What specific circumstances trigger Autovacuum wraparound

2018-06-05 Thread Daniel Lagerman
Hello David! Thanks for taking the time to respond. Upgrading is not in scope right now for this server even though that is certainly something I will do down the line. I talked to a colleague of mine and he dug up something very interesting and probably answers the behavior I'm seeing, from PG

Re: What specific circumstances trigger Autovacuum wraparound

2018-06-04 Thread David G. Johnston
On Monday, June 4, 2018, Daniel Lagerman wrote: > I have a pg 9.4.3 server that has one table with calculate age of about > 320 million, this is the oldest table in this database and therefore the > age of the DB is the same as the table. > It would be advisable to simply upgrade to 9.4.18 and

What specific circumstances trigger Autovacuum wraparound

2018-06-04 Thread Daniel Lagerman
Hello! Please note that I have read: https://www.postgresql.org/docs/current/static/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND And I think i understand how the settings are supposed work, however I do have a question in regards to Autovaccum wrap-around and how it is triggered. I have a pg