2026 Archive

PostgreSQL Weekly posts for 2026.

Weeks

• Week 13
  • UUID and Base32hex Encoding
  • JSONPath String Methods: Cleaning JSON Inside the Path—and a Long Debate About Immutability
• Week 12
  • Reduce Planning Time for Large NOT IN Lists Containing NULL
• Week 11
  • Converting NOT IN Sublinks to Anti-Joins When Safe
• Week 10
  • Generic Plans and Initial Pruning: Fewer Locks for Partitioned Tables
• Week 09
  • More Speedups for Tuple Deformation: Precalculating attcacheoff
• Week 08
  • Eliminating SPI from RI Triggers: A Fast Path for Foreign Key Checks
• Week 07
  • SQL Property Graph Queries (SQL/PGQ): Bringing Graph Queries to PostgreSQL
  • Reducing LEFT JOIN to ANTI JOIN: A Planner Optimization for "WHERE col IS NULL"
• Week 06
  • COPY TO with JSON Format: Native JSON Export from PostgreSQL
• Week 05
  • GOO: A Greedy Join Search Algorithm for Large Join Problems
  • Batching in Executor: Batch-Oriented Tuple Processing
• Week 04
  • PostgreSQL Planner Optimization: Automatic COUNT(*) Conversion
• Week 03
  • Extended Statistics Import/Export Functions
  • pg_plan_advice: Query Plan Control