3 ms·
Postgres is mostly bored (CPU sub 20% utilized) with 60 write requests per second which is normal peak traffic. Even traffic spikes to 100-120 don't usually cha
by davidfischer 5y ago
Postgres is mostly bored (CPU sub 20% utilized) with 60 write requests per second which is normal peak traffic. Even traffic spikes to 100-120 don't usually change that much.
As our ad network grows though, everything has to grow pretty linearly (writes, reads, requests, etc.) and I hope our approach will continue to work well even with double or triple these numbers.
- philipkimmey 5y agoFairly common practice for Postgres setups is to sit pgbouncer (https://www.pgbouncer.org/ https://www.pgbouncer.org/) between your app process and your Postgres instance. Connection setup/tear-down is cheap in MySQL but expensive in Postgres.