Re: [COMMITTERS] pgsql: Lower *_freeze_max_age minimum values. - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [COMMITTERS] pgsql: Lower *_freeze_max_age minimum values.
Date
Msg-id 20151005134539.GC26492@awork2.anarazel.de
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Lower *_freeze_max_age minimum values.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [COMMITTERS] pgsql: Lower *_freeze_max_age minimum values.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2015-10-05 09:39:58 -0400, Tom Lane wrote:
> Andres Freund <andres@anarazel.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Lower *_freeze_max_age minimum values.
Next
From: Tom Lane
Date:
Subject: Re: ON CONFLICT issues around whole row vars,