PGSQL_COMMIT_DELAY

The PGSQL_COMMIT_DELAY variable specifies the time delay between writing a commit record to the write ahead log (WAL) buffer and flushing the buffer out to disk.

Values

Integer (in microseconds)

Default

250

Comments

Together with the PGSQL_COMMIT_SIBLINGS option, this option allows a group of otherwise unrelated transactions to be flushed to disk at the same time, with possible significant performance gain.