How to Manage Connections Efficiently in Postgres, or Any Database

Re:How to Manage Connections Efficiently in Postgres, or Any... by CWuestefeld on Monday October 15, 2018 @02:53PM (#18222560)

Does anyone have an understanding of if and how much this applies to AWS's Aurora service, when operating as a PostgreSQL database?

[ Parent | on HN ]

Re:How to Manage Connections Efficiently in Postgres, or Any... by stephengillie on Monday October 15, 2018 @03:53PM (#18223094)

The Aurora handbook strongly recommends using these techniques, or using a connection proxy if connection pools won't work for your situation. Having too many connections can cause your Aurora instances to scale up as well, limiting database performance, and leaving you with hundreds more instances than you want to pay for.

https://d1.awsstatic.com/whitepapers/RDS/amazon-aurora-conne...

[ Parent | on HN ]

Re:How to Manage Connections Efficiently in Postgres, or Any... by CWuestefeld on Monday October 15, 2018 @04:10PM (#18223234)

Thanks. Your link is for MySQL, but I found a little related info for PostgreSQL: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide...

[ Parent | on HN ]