Re: [COMMITTERS] pgsql: Lower *_freeze_max_age minimum values.

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [COMMITTERS] pgsql: Lower *_freeze_max_age minimum values.
Date: 2015-10-05 13:45:39
Message-ID: 20151005134539.GC26492@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On 2015-10-05 09:39:58 -0400, Tom Lane wrote:
> Andres Freund <andres(at)anarazel(dot)de> writes:
> > How about simply removing that sentence? I.e. something like
> > <literal>autovacuum_freeze_max_age</> larger than the system-wide setting
> > - (it can only be set smaller). Note that while you can set
> > - <literal>autovacuum_freeze_max_age</> very small, or even zero, this is
> > - usually unwise since it will force frequent vacuuming.
> > + (it can only be set smaller).
> > </para>
>
> How about "Setting autovacuum_freeze_max_age to very small values
> is unwise since it will force frequent vacuuming."

Well, you still can't really set it to a very small value - the lower
limits are still 100k/10k for xids/mxids. To me that sentence mostly
made sense with the old logic where no lower limits existed.

Andres

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2015-10-05 13:51:31 Re: [COMMITTERS] pgsql: Lower *_freeze_max_age minimum values.
Previous Message Tom Lane 2015-10-05 13:39:58 Re: [COMMITTERS] pgsql: Lower *_freeze_max_age minimum values.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2015-10-05 13:50:26 Re: ON CONFLICT issues around whole row vars,
Previous Message Tom Lane 2015-10-05 13:39:58 Re: [COMMITTERS] pgsql: Lower *_freeze_max_age minimum values.