LQO 0.2.0 adds lqo serve. Instead of reading a log, LQO now sits between the application and PostgreSQL as a proxy, passes every message through unchanged, and times every query by shape. With a replica to work on, it tries the slow shapes there under …
LQO 0.5.0 adds row-count hints for servers with the pg_hint_plan extension. LQO already times each query’s default plan with EXPLAIN …
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 …
LQO, the studio’s eighteenth project, is a learned query optimizer for PostgreSQL that steers the planner instead of replacing it. …
LQO 0.4.0 lets lqo serve learn across queries. Queries that read the same tables are relatives, and a new one starts from what its relatives …
LQO ran the Join Order Benchmark again, this time with pg_hint_plan, so it could try its row-count hints next to the planner switches. …
LQO 0.3.0 adds active mode to lqo serve. Until now the proxy only learned and reported. With --mode active it applies each setting it has …