News for hackers. Stuff that matters.

A comment on How to Manage Connections Efficiently in Postgres, or Any Database. Parent comment

Re:How to Manage Connections Efficiently in Postgres, or Any... by Mizza on Monday October 15, 2018 @06:03PM (#18224257)
Were you managing your own DB server instance? I don't think client side pools are possible with RDS.
[ Parent | on HN ]
Re:How to Manage Connections Efficiently in Postgres, or Any... by akurilin on Monday October 15, 2018 @06:05PM (#18224269)
We're on RDS right now. We use connection pools from https://www.yesodweb.com/book/persistent
[ Parent | on HN ]
Re:How to Manage Connections Efficiently in Postgres, or Any... by Mizza on Monday October 15, 2018 @06:16PM (#18224374)
Ohhh, I understand. Long day. I got that backwards, I thought there was a server-side option I wasn't aware of. So you don't have a dedicated server with PgBouncer on it, you just move the pooler to where the requests originates from. I think this might be problematic in a highly elastic/distributed architecture but would work if you have a beefy dedicated application instance.
[ Parent | on HN ]
Re:How to Manage Connections Efficiently in Postgres, or Any... by akurilin on Monday October 15, 2018 @06:21PM (#18224425)
Correct, you'd have to instruct your pools to resize as machines are added and removed. We haven't had to do that so far, as we're not that dramatically elastic.
[ Parent | on HN ]