Скачать или смотреть Scaling Postgres Episode 68 | Prepared Plans | Materialization | Recursive CTEs | Safe Migrations

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

In this episode of Scaling Postgres, we discuss prepared plans, materialization, recursive CTEs and how to run safe database migrations.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:24 - Tech preview: How PostgreSQL 12 handles prepared plans
04:08 - Tech preview: Improving COPY and bulkloading in PostgreSQL 12
05:08 - Rethinking the Database Materialized View as an Index
07:18 - Checking the sequences status on a single pass
07:53 - FizzBuzz (in both plpgsql and SQL)
08:39 - A recursive CTE to get information about partitions
09:36 - [YouTube] rails db:migrate:safely by Matt Duszynski
11:27 - [YouTube] When it all goes Wrong (with Postgres) by Will Leinweber
13:07 - [YouTube] Postgres & Rails 6 Multi-DB: Pitfalls, Patterns, Performance by Gabe Enslein
14:32 - Indexes in PostgreSQL — 10 (Bloom)
15:10 - What's New in Crunchy PostgreSQL Operator 4.0
15:38 - Outro

#postgres #postgresql