LQO Finds Faster Plans for 35 of 94 Join Order Benchmark Query Shapes
LQO 0.1.0 has now run the Join Order Benchmark, the standard test for query optimizers: 113 queries over the IMDB movie database, which fold into 94 query shapes. It ran on a 4-core GitHub runner with PostgreSQL 16, each shape tried under the default plan and …