Prepared Plans, Materialization, Recursive CTEs, Safe Migrations | Scaling Postgres 68
In this episode of Scaling Postgres, we discuss prepared plans, materialization, recursive CTEs and how to run safe database migrations.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.cybertec-postgresql.com/en/tech-preview-how-postgresql-12-handles-prepared-plans/
https://www.cybertec-postgresql.com/en/tech-preview-improving-copy-and-bulkloading-in-postgresql-12/
https://blog.timescale.com/rethinking-the-database-materialized-view-as-an-index/
https://fluca1978.github.io/2019/06/11/SequenceCheck.html
https://fluca1978.github.io/2019/06/11/FizzBuzz.html
https://fluca1978.github.io/2019/06/12/PartitioningCTE.html
https://www.youtube.com/watch?v=KROgsx5zosA
https://www.youtube.com/watch?v=B-iq4iHLnJU
https://www.youtube.com/watch?v=a4OBp6edNaM
https://habr.com/en/company/postgrespro/blog/452968/
https://info.crunchydata.com/blog/crunchy-postgres-kubernetes-operator-4.0
Create your
podcast in
minutes
It is Free