2026 Archive

PostgreSQL Weekly posts for 2026.

Weeks

• 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