Loading...
Loading...
Two recent pieces highlight a growing focus on Postgres performance work and pragmatic paths to scale. In a Talking Postgres episode, Tomas Vondra explains why performance hacking in Postgres is uniquely rewarding: improvements often come from deep, measurable wins across query planning, execution, and internals, with benefits shared broadly through the open-source community. Complementing that mindset, a new “agent harness” targets real-world bottlenecks by streamlining migrations from Postgres to ClickHouse, positioning ClickHouse as an analytics offload when Postgres hits throughput or latency limits. Together, they underscore a trend of optimizing Postgres where possible while adopting specialized systems when needed.
&#32; submitted by &#32; <a href="https://www.reddit.com/user/jascha_eng"> /u/jascha_eng </a> <br/> <span><a href="https://www.tigerdata.com/blog/pg-textsearch-bm25-full-text-search-postgres">[link]</a></span> &#32; <span><a href="https://www.reddit.com/r/programming/comments/1s8r2ul/pg_textsearch_10_how_we_built_a_bm25_search/">[comments]</a></span>
&#32; submitted by &#32; <a href="https://www.reddit.com/user/GarethX"> /u/GarethX </a> <br/> <span><a href="https://hookdeck.com/blog/how-we-made-payload-search-60x-faster-in-clickhouse">[link]</a></span> &#32; <span><a href="https://www.reddit.com/r/programming/comments/1rv8eg6/making_payload_search_60x_faster_in_clickhouse/">[comments]</a></span>
Tomas Vondra on Talking Postgres: Why it's fun to hack on Postgres performance
Agent harness for Postgres to ClickHouse migration