Problemsby GlyphTrouble with PostgreSQL jsonb
3 posts from 3 people3d activeSteady, +1 this week
Posts per day
The posts behind it
Atomic JSONB update in Python SQLAlchemy PostgreSQL
I need to update a jsonb column of a specific row in database. It holds a JSON object with session_id : group_key .. On insert some key:value pairs will be added, then I need to add a new session_id to this JSON. It should be one atomic update operation and I don't need to...
Returning on-disc representation of JSONB from PostgreSQL
...jsonb as a version number, then a string of text */ Datum jsonb_send(PG_FUNCTION_ARGS) Is there any way to get on-disc representation of JSONB from Postgres?.
Should semi-structured product attributes (secondary images, specs) be stored as JSONB or normalized tables?
I am designing a relational database schema for an e-commerce platform where the backend receives product objects structured like this:. { "id": 101, "categoryId": 1, "name": "Galaxy S22 Ultra 5G", "price": 67999, "stockQuantity": 18, "imageUrl": "https://...", "imagePublicId":...
Companies and products named
About this problem
Evidence
3 posts from 3 people in 1 place, about 1 a week over 53 days. Mostly on Stack Overflow [postgresql].
Frustration Frustration 0 of 3· Seen on Stack Overflow
How it was grouped
Posts about PostgreSQL with no known issue, sharing the word "jsonb". First post Sep 4, 2026, latest Oct 26, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
Other PostgreSQL problems
PostgreSQL users keep filing bugs
Top post: "Postgres row-level security leaks across tenants when using a pooled connection", one of 41 posts from 40 people on GitHub issues, Stack Overflow, Reddit.
PostgreSQL upgrades break working setups
12 posts from 11 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 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.
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