Aiven PostgreSQL connection pooling

Why connection pooling?

Connection pooling modes

How to get started with Aiven PostgreSQL connection pooling

Verifying the connection pool

 $ psql <pool-uri>
 $ psql <pool-uri>
mypool=> SELECT 1;
?column?
──────────
1
(1 row)
mypool=> SELECT 1;
?column?
──────────
1
(1 row)
 mypool=> SELECT COUNT(*) FROM pg_stat_activity WHERE usename = 'avnadmin';
count
— — — -
1
(1 row)

Summary

Try PostgreSQL 9.6 for free in Aiven

--

--

--

Your database in the cloud, www.aiven.io

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Aiven

Aiven

Your database in the cloud, www.aiven.io

More from Medium

AWS DMS Heartbeat — Avoid Critical Production DB Issues

A quick guide to service mesh

Migrating to AWS Managed Streaming Kafka (MSK)

Legacy to MSK

Scaling microser through sidecars