Reducing WAL, What is Null?, Understanding SQL, TPC-H Benchmarking | Scaling Postgres 104
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.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.cybertec-postgresql.com/en/reduce-wal-by-increasing-checkpoint-distance/
https://www.2ndquadrant.com/en/blog/on-the-impact-of-full-page-writes/
https://www.percona.com/blog/2020/03/05/handling-null-values-in-postgresql/
https://blog.jooq.org/2020/03/02/sql-distinct-is-not-a-function/
https://blog.jooq.org/2020/03/03/better-understand-sql-by-adding-optional-parentheses/
https://rafiasabih.blogspot.com/2020/03/learnings-from-benchmarking-postgresql.html
https://severalnines.com/database-blog/what-look-if-your-postgresql-replication-lagging
https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-4-handling-input-parameters/
https://www.2ndquadrant.com/en/blog/developing-postgresql-windows-part-2/
https://postgresql.life/post/joe_conway/
https://postgres.ai/
https://postgres.ai/blog/joe-0.5/
https://postgres.ai/docs/database-lab/what_is_database_lab
https://info.crunchydata.com/blog/crunchy-spatial-its-postgis-for-the-web
https://info.crunchydata.com/blog/crunchy-spatial-tile-serving
https://pgstef.github.io/2020/03/02/pgbackrest_auto_select_backup.html
https://www.citusdata.com/blog/2020/03/02/citus-9-2-speeds-up-large-scale-htap/
Create your
podcast in
minutes
It is Free