Скачать или смотреть Postgres Releases, Performance Secrets, Don't Do This, Filter vs. Case | Scaling Postgres 252

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 new Postgres releases, performance secrets, things not to do and filter vs. case.

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:27 - PostgreSQL 15.2, 14.7, 13.10, 12.14, and 11.19 Released!
01:15 - Exposing Postgres Performance Secrets
03:02 - FOSDEM 2023 - Don't Do this
03:52 - The Performance Impact of SQL’s FILTER Clause
04:34 - Adventures in embedding Postgres schemas in GPT
05:24 - SQL Tricks for More Effective CRUD
06:50 - Quick Logical Replication Checklist
07:06 - When to use VACUUM FULL
08:03 - Never run VACUUM FULL: How to run pg_repack on Amazon RDS and Aurora
08:25 - Find Text in Any Column of a PostgreSQL Table
09:29 - How to get a row, and all of it’s dependencies?
10:08 - Now you can \d table not only in psql :)
10:44 - Waiting for PostgreSQL 16 – Allow underscores in integer and numeric constants.
11:07 - Reserve connections in PostgreSQL 16
11:41 - Relational or Non-relational Postgres?
12:09 - PGSQL Phriday #005 Recap
12:19 - Invoking (your own) Perl from PL/Perl
12:38 - What’s new in Citus 11.2 for Postgres, plus Patroni HA support for Citus
13:15 - Precompiled headers in PostgreSQL
13:40 - Postgres GitOps with Argo and Kubernetes
13:54 - Benchmarking
14:05 - Bertrand Drouvot
14:15 - Rubber Duck Dev Show Episode 73 | Hobby Programming With Nick Schwaderer
14:31 - Outro

#postgres #postgresql