TGViewer
Computer Science and Programming Computer Science and Programming @computer_science_and_programming · 140K subscribers
Post #2272 22.7K
pg_kpart version 1.0
pg_kpart is a new PostgreSQL extension (v1.0) that enforces partition key usage by rejecting queries that would scan all partitions of a partitioned table. Without a usable predicate on the partition key, such queries cause full-hierarchy scans that saturate I/O and degrade performance for all connected users. The extension turns a fragile developer convention into a database-enforced guarantee, with features including an audit mode for gradual rollout, blacklist/whitelist scoping to target specific tables, and a dedicated SQLSTATE for application-level error handling. It is open source under the PostgreSQL license and available on GitHub.
  • ❤ 15
  • 👍 2
More from @computer_science_and_programming
  1. Oct 3, 2026BYD says it will have a solid-state car next year, the earliest date anyone has given BYD…
  2. Oct 1, 2026Introducing G#: A Go-like language for .NET G# is a new open-source, Go-inspired programmi…
  3. Sep 30, 2026Chrome for Developers Chrome 146 introduces three notable features for web developers. Scr…
  4. Sep 26, 2026Introduction to Solon A comprehensive tutorial walks through building a REST API with Solo…
  5. Sep 25, 2026The strangler fig pattern: modernizing without a big-bang rewrite A detailed guide to the…
  6. Sep 24, 2026Lessons From Four Years of Writing a Weekly Newsletter A .NET blogger reflects on four yea…
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →