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

Commit8728fdc

Browse files
committed
Limit values of archive_timeout, post_auth_delay, auth_delay.milliseconds.
The previous definitions of these GUC variables allowed them to rangeup to INT_MAX, but in point of fact the underlying code would sufferoverflows or other errors with large values. Reduce the maximum valuesto something that won't misbehave. There's no apparent value in workingharder than this, since very large delays aren't sensible for any ofthese. (Note: the risk with archive_timeout is that if we're latechecking the state, the timestamp difference it's being compared tomight overflow. So we need some amount of slop; the choice of INT_MAX/2is arbitrary.)Per followup investigation of bug #7670. Although this isn't a verysignificant fix, might as well back-patch.
1 parent46c79df commit8728fdc

File tree

1 file changed

+2
-2
lines changed
  • src/backend/utils/misc

1 file changed

+2
-2
lines changed

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

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1110,7 +1110,7 @@ static struct config_int ConfigureNamesInt[] =
11101110
GUC_UNIT_S
11111111
},
11121112
&XLogArchiveTimeout,
1113-
0,0,INT_MAX,NULL,NULL
1113+
0,0,INT_MAX /2,NULL,NULL
11141114
},
11151115
{
11161116
{"post_auth_delay",PGC_BACKEND,DEVELOPER_OPTIONS,
@@ -1119,7 +1119,7 @@ static struct config_int ConfigureNamesInt[] =
11191119
GUC_NOT_IN_SAMPLE |GUC_UNIT_S
11201120
},
11211121
&PostAuthDelay,
1122-
0,0,INT_MAX,NULL,NULL
1122+
0,0,INT_MAX /1000000,NULL,NULL
11231123
},
11241124
{
11251125
{"default_statistics_target",PGC_USERSET,QUERY_TUNING_OTHER,

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp