Default setting for autovacuum_freeze_max_age - Mailing list pgsql-hackers

From Bruce Momjian
Subject Default setting for autovacuum_freeze_max_age
Date
Msg-id 20161021131934.GA23502@momjian.us
Whole thread Raw
Responses Re: Default setting for autovacuum_freeze_max_age  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Why is autovacuum_freeze_max_age's default set to 200 million, rather
than something like 2 billion?  It seems 2 billion is half way to
wrap-around and would be a better default.  Right now, the default seems
to freeze 10x more often than it has to.

Does it default to 200 million so clog can be trimmed?  Is that
reasonable?  We have tuple status flags of commit status so I assume
changing from a normal xid to a frozen one doesn't have a performance
benefit, does it?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: emergency outage requiring database restart
Next
From: Stephen Frost
Date:
Subject: Re: Improve output of BitmapAnd EXPLAIN ANALYZE