Re: Default setting for autovacuum_freeze_max_age

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Default setting for autovacuum_freeze_max_age
Date: 2016-10-21 14:44:41
Message-ID: 25553.1477061081@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> 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.

Please see the archives. I do not remember the reasoning, but there
was some, and you need to justify why it was wrong not just assert
that you think it's silly.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-10-21 14:47:08 Re: Aggregate Push Down - Performing aggregation on foreign server
Previous Message Robert Haas 2016-10-21 14:08:30 Re: Aggregate Push Down - Performing aggregation on foreign server