README.md

pggat

pggat is a Postgres pooler similar to PgBouncer. It is different in that it supports load balancing to rdwr/rd replicas.

the name is because this song is a banger

Pooling Modes

There are currently two pooling modes which compromise between balancing and feature support. Most apps should work out of the box with transaction pooling.

Transaction Pooling (default)

Send each transaction to a new node. This mode supports all postgres features that do not rely on session state (plus a few exceptions noted below).

This is similar to PgBouncer's transaction pooling except we additionally support protocol level prepared statements and all parameters (they may change at unexpected times, but clients should be able to handle this)

Using LISTEN commands in this mode will lead to undefined behavior (you may not receive the notifications you want, and you may receive notifications you did not ask for).

Session Pooling