UUID Use Cases, pg_settings, Automated Restore, Parallel Future | Scaling Postgres 102
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-in-psql/
https://www.highgo.ca/2020/02/21/have-an-eye-on-locks-of-postgresql/
https://github.com/mgartner/pg_flame
Create your
podcast in
minutes
It is Free