cooperative_commit_timeout option [deprecated]

Governs when a COMMIT entry in the transaction log is written to disk.

Note As of version 11, this option setting is ignored as commit behavior is automatically tuned.

Allowed values

Integer, in milliseconds

Default

250

Scope

	PUBLIC role	For current user	For other users
Allowed to set permanently?	Yes, with SET ANY PUBLIC OPTION	Yes	Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily?	Yes, with SET ANY PUBLIC OPTION	Yes (current connection only)	No

Remarks

This option has meaning only when cooperative_commits is set to On. The database server waits for the specified number of milliseconds for other connections to fill a page of the log before writing to disk. The default setting is 250 milliseconds.