CentOS help


PGSQL_COMMIT_SIBLINGS

The PGSQL_COMMIT_SIBLINGS variable sets the minimum number of concurrent open transactions to require before performing the delay specified by the PGSQL_COMMIT_DELAY option.

Values

Integer

Default

10

Comments

Together with the PGSQL_COMMIT_DELAY 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