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

YouTube Video