When Postgres blocks: 7 tips for dealing with locks - Citus Data
In our previous post, we explored locking behavior in Postgres and which types of operations hold locks against other. In this post, we highlight 7 common mistakes developers face dealing with Postgres locks. A list of doâs & donâts based on our work with developers building apps on top of Postgres and Citus.
New in postgres 10
Streaming Replication (SR) is a way of achieving High Availability with Postgres. There are many parameter settings that need to be set correctly for streaming replication.
PostgreSQL: Documentation: 17: 47.2. Logical Decoding Concepts
47.2. Logical Decoding Concepts # 47.2.1. Logical Decoding 47.2.2. Replication Slots 47.2.3. Replication Slot Synchronization 47.2.4. Output Plugins 47.2.5. Exported Snapshots …
GitHub - 2ndQuadrant/pglogical: Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades. - 2ndQuadrant/pglogical