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:13
Message-ID: E1Zf64L-0000yH-PO@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

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: back to 9.0 (in parts)

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/020235a5754be6ba1f0d240b4c86c642e1a62d70

Modified Files
--------------
src/backend/utils/misc/guc.c | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2015-09-24 12:56:15 pgsql: Lower *_freeze_max_age minimum values.
Previous Message Gavin Flower 2015-09-24 10:52:49 Re: [COMMITTERS] pgsql: Use gender-neutral language in documentation

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2015-09-24 13:22:35 Re: No Issue Tracker - Say it Ain't So!
Previous Message Masahiko Sawada 2015-09-24 12:37:46 Re: [PROPOSAL] VACUUM Progress Checker.