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

Commit15939a7

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 parent2e06d52 commit15939a7

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
@@ -1287,7 +1287,7 @@ static struct config_int ConfigureNamesInt[] =
12871287
GUC_UNIT_S
12881288
},
12891289
&XLogArchiveTimeout,
1290-
0,0,INT_MAX,NULL,NULL
1290+
0,0,INT_MAX /2,NULL,NULL
12911291
},
12921292
{
12931293
{"post_auth_delay",PGC_BACKEND,DEVELOPER_OPTIONS,
@@ -1296,7 +1296,7 @@ static struct config_int ConfigureNamesInt[] =
12961296
GUC_NOT_IN_SAMPLE |GUC_UNIT_S
12971297
},
12981298
&PostAuthDelay,
1299-
0,0,INT_MAX,NULL,NULL
1299+
0,0,INT_MAX /1000000,NULL,NULL
13001300
},
13011301
{
13021302
{"default_statistics_target",PGC_USERSET,QUERY_TUNING_OTHER,

0 commit comments

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