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

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.cybertec-postgresql.com/en/reduce-wal-by-increasing-checkpoint-distance/"> https://www.cybertec-postgresql.com/en/reduce-wal-by-increasing-checkpoint-distance/</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/on-the-impact-of-full-page-writes/"> https://www.2ndquadrant.com/en/blog/on-the-impact-of-full-page-writes/</a></p> <p><a href= "https://www.percona.com/blog/2020/03/05/handling-null-values-in-postgresql/"> https://www.percona.com/blog/2020/03/05/handling-null-values-in-postgresql/</a></p> <p><a href= "https://blog.jooq.org/2020/03/02/sql-distinct-is-not-a-function/">https://blog.jooq.org/2020/03/02/sql-distinct-is-not-a-function/</a></p> <p><a href= "https://blog.jooq.org/2020/03/03/better-understand-sql-by-adding-optional-parentheses/"> https://blog.jooq.org/2020/03/03/better-understand-sql-by-adding-optional-parentheses/</a></p> <p><a href= "https://rafiasabih.blogspot.com/2020/03/learnings-from-benchmarking-postgresql.html"> https://rafiasabih.blogspot.com/2020/03/learnings-from-benchmarking-postgresql.html</a></p> <p><a href= "https://severalnines.com/database-blog/what-look-if-your-postgresql-replication-lagging"> https://severalnines.com/database-blog/what-look-if-your-postgresql-replication-lagging</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-4-handling-input-parameters/"> https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-4-handling-input-parameters/</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/developing-postgresql-windows-part-2/"> https://www.2ndquadrant.com/en/blog/developing-postgresql-windows-part-2/</a></p> <p><a href= "https://postgresql.life/post/joe_conway/">https://postgre