3 ms·
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 co
by oblio 5y ago
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)
- pharmakom 5y agoOn the lambda point, RDS proxy is a good solution if using AWS.
- mnahkies 5y agoAn 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.