pgagroal 2.1 on Ubuntu 24.04 LTS

Overview

pgagroal is a connection pool that sits in front of a PostgreSQL server and multiplexes client connections onto a much smaller set of reusable backend connections. Applications that open and close database connections rapidly, or that run many short lived workers, otherwise pay PostgreSQL's per connection process cost on every request. pgagroal absorbs that cost once, keeps warm connections ready, validates them in the background, and hands them out in microseconds. It is written in C, uses no threads on the hot path, and speaks the native PostgreSQL protocol, so any client driver works unchanged.

This image is a working pooler rather than a bare binary. A PostgreSQL server is installed as the pooled backend and bound to the loopback interface only, an empty application database and a dedicated non superuser role are created for you, and pgagroal is configured in front of them as the single database endpoint on the network. The same appliance can be repointed at your own PostgreSQL server, or at a managed PostgreSQL service, by editing one section of the pooler configuration.

Common uses

• Absorbing connection churn from web applications and serverless workers
• Raising effective concurrency without raising PostgreSQL max_connections
• Presenting one pooled database endpoint in front of a private PostgreSQL server