Scaling Postgres Episode 104 Reducing WAL | What is Null? | Understanding SQL | TPC-H Benchmarking

In this episode of Scaling Postgres, we discuss how to reduce the size of your WAL files, what is null, how to better understand SQL and exploring TPC-H benchmarks.

Content Discussed

Reduce WAL by increasing checkpoint distance
On the impact of full-page writes
Handling NULL Values in PostgreSQL
SQL DISTINCT is not a function
5 Ways to Better Understand SQL by Adding Optional Parentheses
Learnings from benchmarking PostgreSQL on TPC-H
What to Look for if Your PostgreSQL Replication is Lagging
Creating a PostgreSQL procedural language – Part 4 – Handling Input Parameters
Developing PostgreSQL for Windows, Part 2
Joe Conway
Postgres.ai
Joe bot, an SQL query optimization assistant, updated to version 0.5.0
What Is Database Lab?
Crunchy Spatial: It's PostGIS, for the Web
Crunchy Spatial: Tile Serving
pgBackRest auto-select backup
Citus 9.2 speeds up large scale HTAP workloads on Postgres