We deployed pgbouncer to optimize database connections.
However, post-deployment, we encountered issues with shared advisory locks, resulting in application warnings and support escalations.
Our testing environment did not replicate the application's use of advisory locks. A rollback has been performed.
We are investigating solutions and will conduct more comprehensive testing before future deployments.