Re: delaying autovacuum freeze via storage params?

From: Steve Kehlet <steve(dot)kehlet(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: delaying autovacuum freeze via storage params?
Date: 2015-05-27 16:27:08
Message-ID: CA+bfosGxwSsKQ6EUePSHyvf5kVM3u7H=49EiOe5C8391hoNfzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, May 26, 2015 at 7:27 PM Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:

> See the docs about the freeze max age storage parameter -- the per-table
> setting can decrease the global setting but not increase it.

Thanks Alvaro, that explains it. I found it in the docs: "Note that
autovacuum will ignore attempts to set a
per-tableautovacuum_freeze_max_age larger
than the system-wide setting (it can only be set smaller)."

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rémi Cura 2015-05-27 16:49:34 Python 3.2 XP64 and Numpy...
Previous Message Simon Riggs 2015-05-27 16:21:18 Re: Reg: BULK COLLECT