Skip to main content

PG_CONSENSUS_READ_COMMITTED

Constant PG_CONSENSUS_READ_COMMITTED 

Source
pub const PG_CONSENSUS_READ_COMMITTED: Config<bool>;
Expand description

Flag to run PostgreSQL consensus connections under READ COMMITTED isolation instead of SERIALIZABLE.

The query family used on vanilla Postgres is designed to be linearizable under READ COMMITTED isolation, and therefore is also linearizable under SERIALIZABLE, so this flag can be flipped freely. The flag only exists to make the upgrade path from older versions safe since multiple query versions co-exist during a 0dt upgrade. See the note on the default value for more information.

This flag should stay off on CockroachDB. The system will refuse to issue consensus queries if the flag is enabled on CockroachDB.