6 stories tagged query-optimization, newest first.
169 points by speckx | 79 comments
Blog post examining the 'push ifs up and fors down' coding idiom from TigerBeetle's TigerStyle, relating it to database query optimization and category theory.
14 points by gvsg-rs | 0 comments
Readyset blog post explaining how its query transformation pipeline rewrites SQL queries internally.
647 points by polyphilz | 130 comments
Blog post by Rohan Bansal on training a 4B Qwen model with agentic reinforcement learning to generate query plans faster than Postgres's optimizer.
398 points by haki | 63 comments
Blog post by Haki Benita presenting unconventional, creative techniques for speeding up queries in PostgreSQL beyond standard indexing and query rewrites.
340 points by tbragin | 107 comments
ClickHouse engineering blog post by Tom Schreiber introducing lazy materialization, a query optimization that defers reading column data to speed up queries.
450 points by avinassh | 85 comments
Blog post summarizing the paper "SQLite: Past, Present, and Future" and explaining how Bloom filters made SQLite analytical queries 10x faster.