pgsql: Lower *_freeze_max_age minimum values.

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Lower *_freeze_max_age minimum values.
Date: 2015-09-24 12:56:25
Message-ID: E1Zf64X-00010P-Ej@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Lower *_freeze_max_age minimum values.

The old minimum values are rather large, making it time consuming to
test related behaviour. Additionally the current limits, especially for
multixacts, can be problematic in space-constrained systems. 10000000
multixacts can contain a lot of members.

Since there's no good reason for the current limits, lower them a good
bit. Setting them to 0 would be a bad idea, triggering endless vacuums,
so still retain a limit.

While at it fix autovacuum_multixact_freeze_max_age to refer to
multixact.c instead of varsup.c.

Reviewed-By: Robert Haas
Discussion: CA+TgmoYmQPHcrc3GSs7vwvrbTkbcGD9Gik=OztbDGGrovkkEzQ(at)mail(dot)gmail(dot)com
Backpatch: 9.0 (in parts)

Branch
------
REL9_0_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/078d471a909a07bc7dc93def37b6811e236f8a84

Modified Files
--------------
src/backend/utils/misc/guc.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2015-09-24 13:50:05 Re: [COMMITTERS] pgsql: Add pages deleted from pending list to FSM
Previous Message Andres Freund 2015-09-24 12:56:23 pgsql: Lower *_freeze_max_age minimum values.