NotificationsYou must be signed in to change notification settings
Fork5
Star27

Commit13fe298

committed

Change commit_delay to be SUSET for 9.3+

Prior to 9.3 the commit_delay affected only the current user,whereas now only the group leader waits while holding theWALWriteLock. Deliberate or accidental settings to a poorvalue could seriously degrade performance for all users.Privileges may be delegated by SECURITY DEFINER functionsfor anyone that needs per-user settings in real situations.Request for change from Peter Geoghegan

1 parente690b95 commit13fe298Copy full SHA for 13fe298

File tree

1 file changed

-1

lines changed

src/backend/utils/misc
- guc.c

1 file changed

-1

lines changed

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

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2042,7 +2042,7 @@ static struct config_int ConfigureNamesInt[] =`
`2042`	`2042`	`},`
`2043`	`2043`
`2044`	`2044`	`{`
`2045`		`-{"commit_delay",PGC_USERSET,WAL_SETTINGS,`
	`2045`	`+{"commit_delay",PGC_SUSET,WAL_SETTINGS,`
`2046`	`2046`	`gettext_noop("Sets the delay in microseconds between transaction commit and "`
`2047`	`2047`	`"flushing WAL to disk."),`
`2048`	`2048`	`NULL`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit13fe298

File tree

1 file changed

1 file changed

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

0 commit comments