Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit59f800d

Browse files
Mark vacuum_defer_cleanup_age as PGC_POSTMASTER.
Following bug analysis of #7819 by Tom Lane
1 parent275a86b commit59f800d

File tree

2 files changed

+7
-3
lines changed

2 files changed

+7
-3
lines changed

‎doc/src/sgml/config.sgml‎

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1998,8 +1998,7 @@ SET ENABLE_SEQSCAN TO OFF;
19981998
is measured in terms of number of write transactions occurring on the
19991999
primary server, it is difficult to predict just how much additional
20002000
grace time will be made available to standby queries.
2001-
This parameter can only be set in the <filename>postgresql.conf</>
2002-
file or on the server command line.
2001+
This parameter can only be set at server start.
20032002
</para>
20042003
</listitem>
20052004
</varlistentry>

‎src/backend/utils/misc/guc.c‎

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1631,7 +1631,12 @@ static struct config_int ConfigureNamesInt[] =
16311631
},
16321632

16331633
{
1634-
{"vacuum_defer_cleanup_age",PGC_SIGHUP,WAL_REPLICATION,
1634+
/*
1635+
* Setting this to a higher value without restarting postmaster
1636+
* can cause various bugs in TOAST object removal, CLUSTER and
1637+
* possibly other places, so this must be changed only on restart.
1638+
*/
1639+
{"vacuum_defer_cleanup_age",PGC_POSTMASTER,WAL_REPLICATION,
16351640
gettext_noop("Number of transactions by which VACUUM and HOT cleanup should be deferred, if any."),
16361641
NULL
16371642
},

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp