-
Notifications
You must be signed in to change notification settings - Fork 391
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
RDS Proxy Pinning #1153
Comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I am using asyncpg to query an postgres rds cluster. In my app I use asyncpg connection pools to aquire a connection and query the DB. I recently stood up an RDS Proxy in front of my RDS Cluster and I see almost 100% pinning because of the reset query used by asyncpg. I keep seeing the below message in my RDS Proxy logs for the pinned connections.
Consider moving session configuration to the proxy's initialization query. Digest: "select pg_advisory_unlock_all(); close all; unlisten *; reset all;".
Has anyone else run into connection pinning in RDS Proxy? I feel like the correct approach is not what is mentioned in the logs.
Thanks in advance :)
The text was updated successfully, but these errors were encountered: