title: Benchmarks

Performance Benchmarks

Automated Benchmark Results

Last updated: 2026-02-23 16:21 UTC

These benchmarks are automatically generated by the CI pipeline using pgbench.

Test Environment

  • Pool size: 40 connections
  • Test duration: 30 seconds per test
  • Instance: AWS Fargate (16 vCPU, 32 GB RAM)
  • Workers: pg_doorman: 12, odyssey: 12
  • pgbench jobs: 4 (global override)
  • Started: 2026-02-23 14:58:04 UTC
  • Finished: 2026-02-23 16:21:21 UTC
  • Total duration: 1h 23m 16s

Legend

  • +N%: pg_doorman is N% faster than competitor (e.g., +10% means pg_doorman is 10% faster)
  • -N%: pg_doorman is N% slower than competitor (e.g., -10% means pg_doorman is 10% slower)
  • ≈0%: Equal performance (difference less than 3%)
  • ∞: Competitor failed (0 TPS), pg_doorman wins
  • N/A: Test not supported by this pooler
  • -: Test not executed

Simple Protocol

Testvs pgbouncervs odyssey
1 client-8%-9%
40 clients+40%-39%
120 clientsx3.0-5%
500 clientsx2.8+4%
10,000 clientsx2.8+20%
1 client + Reconnect-4%x233.7
40 clients + Reconnect+22%x2.1
120 clients + Reconnect+22%x2.2
500 clients + Reconnect+21%+93%
10,000 clients + Reconnect+69%x2.3
1 client + SSL-3%-5%
40 clients + SSL+70%-28%
120 clients + SSLx3.3≈0%
500 clients + SSLx3.3+5%
10,000 clients + SSLx3.5+19%

Extended Protocol

Testvs pgbouncervs odyssey
1 client≈0%+39%
40 clients+52%-8%
120 clientsx3.0+42%
500 clientsx3.0+56%
10,000 clientsx2.9+78%
1 client + Reconnect≈0%x15.5
40 clients + Reconnect+21%x3.1
120 clients + Reconnect+21%+87%
500 clients + Reconnect+21%x2.5
10,000 clients + Reconnect+68%x3.2
1 client + SSL+4%+40%
40 clients + SSL+72%≈0%
120 clients + SSLx3.4+49%
500 clients + SSLx3.6+61%
10,000 clients + SSLx3.6+85%
1 client + SSL + Reconnect+6%+11%
40 clients + SSL + Reconnect+93%≈0%
120 clients + SSL + Reconnect+95%≈0%
500 clients + SSL + Reconnect+91%≈0%
10,000 clients + SSL + Reconnect+90%≈0%

Prepared Protocol

Testvs pgbouncervs odyssey
1 client-7%-11%
40 clients+72%-42%
120 clientsx3.7-10%
500 clientsx3.6+3%
10,000 clientsx3.4+21%
1 client + Reconnect≈0%+48%
40 clients + Reconnect≈0%∞
120 clients + Reconnect+5%∞
500 clients + Reconnect+8%∞
10,000 clients + Reconnect+24%∞
1 client + SSL-4%-7%
40 clients + SSLx2.0-33%
120 clients + SSLx3.9-5%
500 clients + SSLx4.2+7%
10,000 clients + SSLx4.0+23%

Notes

  • Odyssey has poor support for extended query protocol in transaction pooling mode, resulting in significantly lower performance compared to pg_doorman and pgbouncer
  • Important: The values shown are relative performance ratios, not absolute TPS numbers. While absolute TPS values may vary depending on hardware and system load, the relative ratios between poolers should remain consistent when tests are run sequentially in a short timeframe (30 seconds each). This allows for fair comparison across different connection poolers under identical conditions