Pain point · Performance · Causes churn
Transaction pooler hangs on indexed queries
1 source thread · first seen 2026-09
Summary
The transaction pooler intermittently leaves trivial indexed queries active until the caller times out, causing production outages. The same query works reliably through the direct/session pooler.
- Affects
- Production application team
- Workaround
- Use the direct/session pooler on port 5432.
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“sat in pg_stat_activity as state=active, wait_event_type=Client, wait_event=ClientRead for 5+ minutes”