pgstream: Cracking the Code on PostgreSQL Snapshot Performance

Recent pgstream releases have dramatically improved PostgreSQL snapshot performance. Initially, the write path was the bottleneck. By switching to bulk ingestion (COPY FROM) and deferring index creation, pgstream now outperforms pg_dump/pg_restore in snapshot speed. Further improvements to batch configuration ensure more stable and efficient snapshot handling across varied data sizes and table structures.