Replicating data from PostgreSQL to analytical engines usually relies on logical decoding plugins like pgoutput or Debezium. While logical decoding provides clean JSON or Avro streams, it introduces severe serialization overhead, struggles to keep pace with high-throughput OLTP workloads, and frequently causes catalog bloat when consumers lag.
Walshadow takes a radically different route by replicating rows into ClickHouse directly from PostgreSQL physical write-ahead log (WAL). Instead of decoding logical tuples inside the database server process, it reads raw physical WAL records, tracks schema evolution, and batches analytical writes downstream.
Operating at the physical WAL level eliminates the query performance penalty on primary nodes and unlocks sub-second analytical ingestion latency. It handles initial backfills, continuous changelogs, and planned failover switches natively.
Bypassing the logical replication engine transforms how teams architect real-time OLAP pipelines on top of high-traffic relational backends.








