Description

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 via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

Postgres FM is produced by:

• Michael Christofides, founder of pgMustard
• Nikolay Samokhvalov, founder of Postgres.ai

With credit to:

• Jessie Draws for the elephant artwork