Databases · Senior · Question 33 of 75

Which pitfalls come with PgBouncer in transaction pooling mode?

✓Correct answer: Session state isn't preserved between transactions: session-level SET, advisory locks, LISTEN and (in older versions) prepared statements break
2It doesn't support SSL
3It works only with MySQL

Explanation

Each transaction may run on a different server connection. Use transaction-scoped settings (SET LOCAL) and recent PgBouncer versions that support protocol-level prepared statements.

Which pitfalls come with PgBouncer in transaction pooling mode?

Explanation

Further reading

Problem with a question

Test yourself