#performance

3 posts

May 26, 2026 Tech

Part 4 - PgBouncer to ProxySQL: Extended and Prepared Protocols

Part 4 of the PgBouncer to ProxySQL series. Benchmarks ProxySQL and PgBouncer under PostgreSQL's extended and prepared query protocols. ProxySQL keeps the lead and widens it as worker threads increase.

#proxysql #postgresql #pgbouncer #benchmark #performance #tps #ssl #extended-query #prepared-statements #dba #sre

May 22, 2026 Tech

Part 3 - PgBouncer to ProxySQL: Simple-Mode Benchmark

Benchmarking the PostgreSQL middle tier under SSL — PgBouncer vs ProxySQL (1/2/4 workers), same hardware, same 4KB SELECT workload. pgbench simple mode.

#proxysql #postgresql #pgbouncer #benchmark #performance #tps #ssl #dba #sre

April 16, 2026 Tech

zstd Compression Support in ProxySQL 3.0.7

ProxySQL 3.0.7 adds native zstd compression for the MySQL protocol, offering better compression ratios and lower CPU overhead compared to zlib.

#proxysql-3-0 #mysql #compression #performance