Overcoming Pitfalls of Postgres Logical Decoding

PeerDB is building a fast and simple way to replicate data from Postgres to various data warehouses and queues. They use Postgres Change Data Capture (CDC) for reliable replication, which relies on Logical Decoding. However, there are some pitfalls with Logical Decoding that users need to overcome. These include unexpected replication slot growth, long-running transactions, and limitations in supporting generated columns. PeerDB has addressed many of these issues in their product and continues to work closely with customers to find and implement workarounds for the remaining challenges.