DevelopersTV

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

Postgresql Performance Optimization Postgres Wal Physical Replication Pgbench Benchmarking Database Performance Perf Tools Replication Latency Posette Postgresql Internals
Microsoft Developer
AI summary

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.

Related videos