Skip to content

todo.md

Latest commit

 

History

History
70 lines (56 loc) · 2.88 KB

todo.md

File metadata and controls

70 lines (56 loc) · 2.88 KB

SQL Saga - TODO

A living document of upcoming tasks.

Current Priority - Critical Issues & Bugs

(None - all critical issues resolved)

Medium Priority - Refactoring & API Improvements

  • Automate README.md example testing (literate programming approach)
  • Improve test documentation for complex/expected-failure cases

Future Work & New Features

  • Package with pgxman for easier distribution

Done

2026-02-22: Executor Optimization & Pre-Merge Hardening

  • Native Rust executor introspection cache (zero SPI on cache hit)
  • Partition-by-NULL optimization for XOR nullable identity columns
  • Mutually exclusive partition filters for non-XOR correctness
  • PATCH_FOR_PORTION_OF extending-range bug fix
  • REPLACE/DELETE_FOR_PORTION_OF extending-range regression tests
  • Benchmark EXPLAIN log support for native planner

2026-01-22: System Time Feature Complete

  • Completed system_time (system versioning) with full test coverage
  • Drop/rename protection for history tables, views, query functions, triggers
  • Health checks: GRANT/REVOKE/ownership propagation to history objects
  • Era-level ephemeral_columns (fixes statbus coalescing regression)
  • New test: 023_system_versioning_query_functions.sql

2026-01-21: temporal_merge ANALYZE Optimization

  • Added ANALYZE to temp table before executor DML (5x speedup)
  • Fixes PostgreSQL underestimating row counts on temp tables

2026-01-20: temporal_merge Performance Optimizations

  • Hash join optimizations: = instead of IS NOT DISTINCT FROM (470-500x speedup for specific queries)
  • Pre-extract entity_keys in subquery (30-38% speedup)
  • Move DEFAULT column exclusion to planner

2026-01-20: Statbus FOR_PORTION_OF Bug Fixes

  • Fix name merging bug: compute intersection with OLD row's timeline
  • Fix ephemeral column preservation: preserve target values when no source data
  • Support explicit NULL assignment via UPDATE_FOR_PORTION_OF mode

2026-01-19: Performance Optimization Phase Complete

  • Regular DML: ~24,000-45,000 rows/s
  • temporal_merge batched: ~2,650-8,310 rows/s
  • Removed unused FK trigger columns (fk_insert_trigger, fk_update_trigger)
  • Template-based sync triggers: 2.3x faster INSERTs, 2.2x faster UPDATEs
  • Eclipse detection optimizations with composite indexes

2026-01-18

  • Eliminate LATERAL jsonb_populate_record (~48% UPDATE speedup)
  • Pre-computed valid_range columns in temporal_merge_plan
  • Add compound index (id, valid_range) to unique keys (~20x speedup)

2026-01-17

  • Split-path approach for resolved_atomic_segments (~10x speedup)
  • CASE→OR optimization (36-56% speedup)
  • Range-only view tests and same-day DELETE fix
  • Makefile renumber-tests-from target

Earlier

  • PostgreSQL 18 native temporal features (WITHOUT OVERLAPS, temporal FKs)
  • Smart MOVE batching with multirange types
  • System versioning implementation
  • C-based FK triggers
  • Event trigger support
  • [valid_from, valid_until) period semantics