Integer, in milliseconds

500

Can be set for an individual connection or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for another user or role. Takes effect immediately.

This option has meaning only when delayed_commits is set to On. it governs when a COMMIT entry in the transaction log is written to disk. With delayed_commits set to On, the database server waits for the number of milliseconds set in the delayed_commit_timeout option for other connections to fill a page of the log before writing the current page contents to disk.

• delayed_commits option
• cooperative_commit_timeout option
• cooperative_commits option
• COMMIT statement
• Propriété de connexion delayed_commit_timeout