The fastest Postgres inserts

A series of optimizations dramatically improved Postgres write performance, from 2,000 writes/second to over 90,000 writes/second. Key strategies included reducing network latency, using connection pooling, optimizing connection counts, implementing batched inserts, and utilizing the COPY command. The study also explored the trade-offs between throughput and latency, finding that a batch size of 25 rows nearly maximized throughput while maintaining reasonable latency. These findings demonstrate that Postgres can scale significantly with proper configuration and application-side optimizations.