Problemsby GlyphTrouble with PostgreSQL table
3 posts from 3 people3d activeRising, +2 this week
Posts per day
The posts behind it
`CREATE TABLE ... AS mysql(..., SETTINGS ...)` and `AS postgresql(..., SETTINGS ...)` do not store the `SETTINGS`, so the table loses them after a restart
...table is created without connecting when the columns are given, and the `mysql` one fails to connect, which shows its connect timeout. A second run on the same path: ### Expected behavior The stored definition keeps the `SETTINGS` argument, as for `s3`, `executable` and, since...
SQL Expressions: Repeated column names in a table input fail with ambiguous column name
...can be read in SQL, and alert labels keep both values. ### Did this work before? No. ### How do we reproduce it? 1. Add a PostgreSQL query that returns two `host` columns: 2. Add an SQL expression: `SELECT host, value FROM A`. 3. The expression fails with `ambiguous column name...
Table design question
Looking for advice on alternative table designs. Not a live application, just for my own learning.. Let's say we have an order table.. Option 1: we keep billing/shipping addresses and contacts copied from the customer as a historical snapshot:. sql CREATE TABLE order ( id UUID...
Companies and products named
About this problem
Evidence
3 posts from 3 people in 3 places, about 1 a week over 43 days. Mostly on r/PostgreSQL, grafana/grafana, ClickHouse/ClickHouse. Tools named alongside: MySQL, Grafana, ClickHouse, GitHub.
Frustration Frustration 0 of 3· Seen on GitHub issues, Reddit
How it was grouped
Posts about PostgreSQL with no known issue, sharing the word "table". First post Sep 14, 2026, latest Oct 26, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
Other PostgreSQL problems
PostgreSQL hits connection, locking and scaling limits
2 posts from 2 people on Reddit, GitHub issues. Unverified.
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