news.ycombinator.com
Ask HN: I'm a New PostgreSQL Hacker – What Problems Do You Face with Postgres?
To learn and grow as a Postgres hacker, I want to hear directly from you—PostgreSQL users—about the problems you face, big or small. These could be operational challenges, performance bottlenecks, confusing behaviors, missing features, or friction points in your workflows. ... That and the updates being a royal pain. DumBthInker007 13 days ago ... EDIT: Missing primary keys in-between also bothers me, however, never found a decent solution for this at scale.
Related Pain Points2件
No In-Place Major Version Upgrades
8PostgreSQL does not support in-place major version upgrades. Upgrades require either dumping and restoring the entire dataset or setting up logical replication, with rigorous application compatibility testing required. Delaying upgrades increases complexity and risk, as outdated versions miss critical security patches, transforming routine maintenance into a complex, high-risk migration project.
Difficulty managing missing primary keys at scale
5Managing tables without primary keys presents challenges that scale poorly. No decent solution exists for identifying and managing missing primary keys in large-scale PostgreSQL deployments.