RegreSQL

From Postgres FM by Nikolay Samokhvalov and Michael Christofides

January 16, 2026 · 58 min · Episode 169

About this episode

Nik and Michael discuss RegreSQL, a regression testing tool for SQL queries, with guest Radim Marek.

Nik and Michael are joined by Radim Marek from boringSQL to talk about RegreSQL, a regression testing tool for SQL queries they forked and improved recently. Here are some links to things they mentioned: Radim Marek https://postgres.fm/people/radim-marek boringSQL https://boringsql.com RegreSQL: Regression Testing for PostgreSQL Queries (blog post by Radim) https://boringsql.com/posts/regresql-testing-queries Discussion on Hacker News https://news.ycombinator.com/item?id=45924619 Radim’s fork of RegreSQL on GitHub https://github.com/boringSQL/regresql Original RegreSQL on GitHub (by Dimitri Fontaine) https://github.com/dimitri/regresql The Art of PostgreSQL (book) https://theartofpostgresql.com How to make the non-production Postgres planner behave like in production (how-to post by Nik) https://postgres.ai/docs/postgres-howtos/performance-optimization/query-tuning/how-to-imitate-production-planner Just because you’re getting an index scan, doesn't mean you can’t do better! (Blog post by Michael) https://www.pgmustard.com/blog/index-scan-doesnt-mean-its-fast boringSQL Labs https://labs.boringsql.com ~~~ What did you like or not like? What should we discuss next time? Let us know…

People in this episode

Hosts: Nik, Michael

Guest: Radim Marek

Topics covered

regression testing
SQL queries
PostgreSQL
boringSQL
software development

Keywords

RegreSQL
SQL
regression testing
PostgreSQL
boringSQL
software testing
Hacker News

Mentioned in this episode

Organizations: boringSQL, Hacker News, GitHub, Postgres FM

Books & works: The Art of PostgreSQL, RegreSQL, How to make the non-production Postgres planner behave like in production, Just because you’re getting an index scan, doesn't mean you can’t do better!