Journey of developing a performance optimization feature in PGSQL | POSETTE 2026

Why watch

A PostgreSQL developer shares her systematic approach to diagnosing and optimizing database performance issues, demonstrating how to use perf and pgbench for benchmarking. The talk focuses on a specific optimization to PostgreSQL's physical replication that allows WAL senders to transmit records to standbys before disk flush, reducing replication latency by leveraging WAL buffers for proactive data transmission.