Scaling Postgres

In this episode of Scaling Postgres, we discuss the release of Postgres 12, how to use window frames, the different index types, and when to use synchronous replication. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1975/ https://www.2ndquadrant.com/en/blog/webinar-new-features-postgres-12/ https://www.2ndquadrant.com/en/blog/pg12-a-few-special-case-performance-enhancements/ https://mjk.space/advances-sql-window-frames/ https://www.citusdata.com/blog/2019/09/26/what-djangocon-has-to-do-with-postgres-and-crocodiles/ http://rhaas.blogspot.com/2019/09/synchronous-replication-is-trap.html https://www.depesz.com/2019/09/26/how-to-run-short-alter-table-without-long-locking-concurrent-queries/ https://momjian.us/main/blogs/pgblog/2019.html#September_27_2019 https://www.cybertec-postgresql.com/en/using-row-level-security-to-make-large-companies-more-secure/ https://blog.taadeem.net///english/2019/09/23/new_version_of_