| 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:20 |
| Message-ID: | E1Zf64S-0000zL-1K@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | 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: back to 9.0 (in parts)
Branch
------
REL9_3_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/fee2275ae9602de2ef773af9e1906b68290f4570
Modified Files
--------------
src/backend/utils/misc/guc.c | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2015-09-24 12:56:21 | pgsql: Lower *_freeze_max_age minimum values. |
| Previous Message | Andres Freund | 2015-09-24 12:56:17 | pgsql: Lower *_freeze_max_age minimum values. |