~postgresweekly | Issue 572 - Are you qualified to use NULL? (10)

pg_qualstats: Extension for Collecting Statistics About Predicates — Analyze the most often used predicates in queries against your database, perhaps as a way to create more effective indexes. Part of the POWA (Postgres Workload Analyzer) project.

What's So Great About Postgres 17? — Finally, Postgres 17 is here and we’re starting to see some opinionated takes on its many enhancements. Laurenz covers the things that caught his eye here.

Are You Qualified to Use NULL in SQL? — A fun(?) quiz designed to test your intuitions about the behavior of NULL and how it interacts with other types, predicates, aggregations, and more. It’s a real brainscratcher. (Note: My Postgres, at least, behaves differently to the expected answer on the final question, showing just how confusing it all is.)

▶  Heroku's Glory Days and Postgres vs The World — Postgres legend Craig Kerstiens joined Aaron Francis (working on the soon to be launched Mastering Postgres course) to talk about his history with Postgres at Heroku, Citus Data, and now Crunchy Data. It’s not all about him, though; the interview is packed with insights about building ecosystems, scaling Postgres, and even DuckDB.

▶  SQL IN Clauses are Miles Faster in Postgres 17 — Hussein is so amazed by PG17’s enhancements to b-tree scanning performance when using IN that he’s recorded a screencast explaining how it works, compares it to SQL Server’s approach, and shows it off with a live demo.

Waiting for Postgres 18: Add Temporal PRIMARY KEY and UNIQUE Constraints — Postgres 17 may have just landed, but Hubert is looking ahead to Postgres 18, and a new way to enforce uniqueness across a time period, say, using WITHOUT OVERLAPS rather than just against static values.

Exploring the Limits of Postgres: When Does It Break? — Postgres’ limits are well understood on paper, but how far could you push a single node Postgres server in the real world and where are the bottlenecks?

pg_stat_kcache: Gather Statistics About Disk Access and CPU Consumption — Sits atop pg_stat_statements and creates views you can use to measure CPU time, page faults, swaps, bytes read and written, and more at both database and query level.

pgsql-tweaks: A Grab Bag of Useful Postgres Functions — An interesting suite of functions that the author (a former PostgreSQL Person of the Week) uses in her day job as a Postgres user, covering areas like checking data types, gathering statistics, some aggregates, and conversion functions.

Run GitHub Actions Up to 2x Faster at Half the Cost — Blacksmith runs your GitHub Actions substantially faster by running them on modern gaming CPUs. Integrating Blacksmith is a one-line code change. 100+ companies like Ashby, Superblocks, and Slope use Blacksmith to help developers merge code faster.