Scaling Postgres

In this episode of Scaling Postgres, we discuss the use cases for UUIDs, using pg_settings, setting up an automated restore and the future of parallelism. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.depesz.com/2020/02/19/why-im-not-fan-of-uuid-datatype/ https://medium.com/yugabyte/natural-versus-surrogate-primary-keys-in-a-distributed-sql-database-the-distributed-sql-blog-886a6d5f8fa2 https://medium.com/@shawnoy/generate-a-uuid-as-postgresql-default-value-fc0ae41a37d2 https://fluca1978.github.io/2020/02/13/pgsettings.html https://pgdash.io/blog/testing-postgres-backups.html http://amitkapila16.blogspot.com/2020/02/this-blog-post-is-about-journey-of.html https://www.cybertec-postgresql.com/en/shared_buffers-looking-into-the-postgresql-i-o-cache/ https://www.depesz.com/2020/02/18/which-tables-should-be-auto-vacuumed-or-auto-analyzed-update/ https://www.depesz.com/2020/02/17/waiting-for-postgresql-13-add-x-to-default-prompt1-and-prompt2