Search

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


	Podcast:		Scaling Postgres
	Episode:		Episode 104 Reducing WAL \| What is Null? \| Understanding SQL \| TPC-H Benchmarking
	Category:		Technology
	Duration:		00:15:21
	Publish Date:		2020-03-09 00:21:11
	Description:		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/
	Total Play:		0