Episode 102 UUID Use Cases | pg_settings | Automated Restore | Parallel Future

<p>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.</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.depesz.com/2020/02/19/why-im-not-fan-of-uuid-datatype/"> https://www.depesz.com/2020/02/19/why-im-not-fan-of-uuid-datatype/</a></p> <p><a href= "https://medium.com/yugabyte/natural-versus-surrogate-primary-keys-in-a-distributed-sql-database-the-distributed-sql-blog-886a6d5f8fa2"> https://medium.com/yugabyte/natural-versus-surrogate-primary-keys-in-a-distributed-sql-database-the-distributed-sql-blog-886a6d5f8fa2</a></p> <p><a href= "https://medium.com/@shawnoy/generate-a-uuid-as-postgresql-default-value-fc0ae41a37d2"> https://medium.com/@shawnoy/generate-a-uuid-as-postgresql-default-value-fc0ae41a37d2</a></p> <p><a href= "https://fluca1978.github.io/2020/02/13/pgsettings.html">https://fluca1978.github.io/2020/02/13/pgsettings.html</a></p> <p><a href= "https://pgdash.io/blog/testing-postgres-backups.html">https://pgdash.io/blog/testing-postgres-backups.html</a></p> <p><a href= "http://amitkapila16.blogspot.com/2020/02/this-blog-post-is-about-journey-of.html"> http://amitkapila16.blogspot.com/2020/02/this-blog-post-is-about-journey-of.html</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/shared_buffers-looking-into-the-postgresql-i-o-cache/"> https://www.cybertec-postgresql.com/en/shared_buffers-looking-into-the-postgresql-i-o-cache/</a></p> <p><a href= "https://www.depesz.com/2020/02/18/which-tables-should-be-auto-vacuumed-or-auto-analyzed-update/"> https://www.depesz.com/2020/02/18/which-tables-should-be-auto-vacuumed-or-auto-analyzed-update/</a></p> <p><a href= "https://www.depesz.com/2020/02/17/waiting-for-postgresql-13-add-x-to-default-prompt1-and-prompt2-in-psql/"> https://www.depesz.com/2020/02/17/waiting-for-postgresql-13-add-x-to-default-prompt1-and-prompt2-in-psql/</a></p> <p><a href= "https://www.