SuSE help


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.

Related questions
What are the right PostgreSQL settings for my site?
More information
Full list of performance-related PosgreSQL parameters
PosgreSQL performance tips from the experts