
Scaling Postgres Episode 104 Reducing WAL | What is Null? | Understanding SQL | TPC-H Benchmarking
Get New Episodes Weekly!
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