Skip to content

Writing Projects About

New posts by email, roughly twice a month. Subscribe or RSS

now life log contact resume privacy

© 2026 Samba Siva Reddy · served from PostgreSQL · \q

● completed · Dec 2025 · featured

Join Order Optimizer for PostgreSQL

#postgresql #go

Join Order Optimizer for PostgreSQL preview

pg_join_optimizer is a statistics-driven optimizer CLI for PostgreSQL Systems.

features

Collects global NDV stats per table and columns
Stores mergeable cardinality stats for join pairs
Computes join costs using NDV
Generates optimized join orders based on collected stats
CLI-based built with Go and Cobra library