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

To get the show notes as well as get notified of new episodes, visit:

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.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:25 - Reduce WAL by increasing checkpoint distance
02:21 - On the impact of full-page writes
03:25 - Handling NULL Values in PostgreSQL
05:26 - SQL DISTINCT is not a function
06:23 - 5 Ways to Better Understand SQL by Adding Optional Parentheses
08:31 - Learnings from benchmarking PostgreSQL on TPC-H
09:57 - What to Look for if Your PostgreSQL Replication is Lagging
10:44 - Creating a PostgreSQL procedural language – Part 4 – Handling Input Parameters
11:08 - Developing PostgreSQL for Windows, Part 2
11:29 - Joe Conway
12:46 - Crunchy Spatial: It's PostGIS, for the Web
13:35 - Crunchy Spatial: Tile Serving
14:09 - pgBackRest auto-select backup
14:30 - Citus 9.2 speeds up large scale HTAP workloads on Postgres
14:57 - Outro

#postgres #postgresql

[MichaelJendryke]

Thanks again for the updates - especially the PostGIS part is interesting.