Problemsby GlyphPostgreSQL hits connection, locking and scaling limits
2 posts from 2 people2d activeNew, +2 this weekunverified
Posts per day
The posts behind it
Our databases class was all ER diagrams, now looking for a backend coding course on how an app talks to Postgres
...draw a perfect ER diagram. Then I tried to build a small app against Postgres and was stuck on the basics. Connection pooling, migrations, why my ORM sends 40 queries to render 1 page. I want a backend coding course that covers the app side of the database and im deciding...
A table created `AS postgresql(...)` or `AS mysql(...)` takes its connection pool settings from the context that loads it, so they change after a restart
### Describe what's wrong A table created from the `postgresql` or `mysql` table function (`CREATE TABLE t (...) AS postgresql(...)`) builds its connection pool once, when the table is loaded, from the query-level settings of the context that loads it: the session of `CREATE`,...
Companies and products named
About this problem
Evidence
2 posts from 2 people in 2 places, about 2 a week over 3 days. Mostly on r/PostgreSQL, ClickHouse/ClickHouse. Tools named alongside: MySQL, ClickHouse, GitHub.
Frustration Frustration 0 of 3· Seen on Reddit, GitHub issues
How it was grouped
Posts that state a pain and match the "db-scaling" rule about PostgreSQL. First post Oct 22, 2026, latest Oct 24, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
The same problem elsewhere
Databases hit connection, locking and scaling limits
13 posts from 13 people on GitHub issues, Hacker News.
GitHub hits connection, locking and scaling limits
6 posts from 6 people on GitHub issues.
MLflow hits connection, locking and scaling limits
3 posts from 3 people on GitHub issues.
PyTorch hits connection, locking and scaling limits
2 posts from 2 people on GitHub issues. Unverified.
ClickHouse hits connection, locking and scaling limits
2 posts from 2 people on GitHub issues. Unverified.
Mistral hits connection, locking and scaling limits
2 posts from 2 people on GitHub issues. Unverified.
Other PostgreSQL problems
Trouble with PostgreSQL table
Top post: "`CREATE TABLE ... AS mysql(..., SETTINGS ...)` and `AS postgresql(..., SETTINGS ...)` do not store the", one of 3 posts from 3 people on GitHub issues, Reddit.
PostgreSQL users keep asking for help
Top post: "Postgres row-level security leaks across tenants when using a pooled connection", one of 44 posts from 42 people on GitHub issues, Stack Overflow, Reddit.
PostgreSQL upgrades break working setups
10 posts from 9 people on GitHub issues, Stack Overflow, Reddit.
PostgreSQL queries run too slowly and are hard to tune
7 posts from 7 people on Reddit, Stack Overflow, GitHub issues.
PostgreSQL error messages are cryptic
6 posts from 6 people on GitHub issues, Stack Overflow.
Trouble with PostgreSQL database
Top post: "Canonicalising unit names from a flat file in a normalised database structure", one of 5 posts from 5 people on GitHub issues, Stack Overflow.
PostgreSQL permissions are confusing and error-prone
5 posts from 5 people on GitHub issues, Hacker News.
PostgreSQL feels slow and laggy
4 posts from 4 people on Mastodon, Reddit, GitHub issues.
PostgreSQL connectors and syncs are fragile
4 posts from 4 people on GitHub issues, Hacker News.
Trouble with PostgreSQL empty
Top post: "Execute Workflow deletes saved input mappings when its workflow ID expression resolves to empty", one of 3 posts from 3 people on GitHub issues.
Trouble with PostgreSQL credentials
Top post: "SFTP Credentials: Port field clears value and incorrectly formats large port numbers", one of 3 posts from 3 people on GitHub issues.
Trouble with PostgreSQL shared
Top post: "The same UPDATE intermittently needs far more shared buffers for about a minute", one of 3 posts from 3 people on GitHub issues, Stack Overflow.
History