News for hackers. Stuff that matters.

A comment on An early look at Postgres 14: Performance and monitoring Improvements. Parent comment

Re:An early look at Postgres 14: Performance and monitoring ... by oblio on Saturday May 22, 2021 @04:55PM (#27250187)
Yeah, to list a bit:

- scaling is non-trivial (you can't just add a node and have PostgreSQL automagically Do The Right Thing™)

- you can only have so many connections open to the database, causing issues with things such as AWS Lambda

- I don't remember if this was changed, but I got the impression a while ago that having dynamic DB users was a bit cumbersome to set up (plug PostgreSQL to AD/LDAP)

[ Parent | on HN ]
Re:An early look at Postgres 14: Performance and monitoring ... by mnahkies on Sunday May 23, 2021 @04:48AM (#27253403)
An external connection pooler like pgbouncer can alleviate some of the simultaneous connection limits

There are projects to automate the syncing of LDAP users to postgres but it would be nice if this was built-in.

However I get the impression that part of the reason these features aren't in the box is to limit scope creep in the main project.

[ Parent | on HN ]
Re:An early look at Postgres 14: Performance and monitoring ... by pharmakom on Sunday May 23, 2021 @03:19AM (#27253032)
On the lambda point, RDS proxy is a good solution if using AWS.
[ Parent | on HN ]