Hacker News Reader

Wondering about pgbouncer: A postgres connection can have state attached, e.g. with 'set'. Does pgbouncer save and restore state, with associated perf cost, or does any pooled connection just receive the random state from the previous connection owner, assuming all state should be identical?

View on HN

pgbouncer supports session and transaction pooling. With session pooling a connection will be associated with the same session throughout its use. With transaction pooling each transaction on the connection could potentially get a different session.

It's configurable. The default in "session pooling" mode is to run DISCARD ALL to reset the connection for reuse.

Reply on news.ycombinator.com