Thursday, May 12, 2022

[google-cloud-sql-discuss] Re: Recommended cloud sql postgresql client settings

Did you follow Google's documentation to setup the postgresql instance? If you use Google's documentation, can you share it please?  The recommended settings are always part of Google's documentation. 


Here is a google document to create a  PostgreSQL instance [1]


[1]:https://cloud.google.com/sql/docs/postgres/create-instance

On Wednesday, May 11, 2022 at 4:26:36 PM UTC-5 r...@transcarent.ai wrote:
We have a postgresql v13 instance where we get occasionally "connection reset by peer" errors.

We are not using the Cloud SQL Auth proxy.

Code is in golang and using pgx driver with database/sql Interface.

For each client, we have a max connection of 20, a max idle connection of 5, and max connection life time of 5 minutes.

We are deploying multiple clients with these settings. Looking in in the graph of active connections, we have a max of 500 and in the last week have a max active connection of 14.

Are there some recommend settings that we should be using to prevent us from getting these 
 occasional "connection reset by peer" errors?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a663055f-97ab-4d6a-994c-3f0532f3821dn%40googlegroups.com.

No comments:

Post a Comment