Скачать или смотреть Scaling Postgres Episode 180 Aggregate Filter | Insert-Only & Vacuum | Out-of-sync Sequences

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 how to use aggregate filters, the importance of vacuum with insert-only tables, how to fix out-of-sync sequences and faster functional index options.

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 - Fast, Flexible Summaries with Aggregate Filters and Windows
02:25 - Insert-Only Tables and Autovacuum Issues Prior to PostgreSQL 13
05:19 - Fixing out-of-sync sequences in PostgreSQL
07:46 - Index Only Scan on Functional Indexes
09:34 - PostgreSQL Database Security: OS – Authentication
10:43 - How to get advisory lock in shell?
11:53 - Announcing PG_DBMS_JOB in PostgreSQL for Oracle DBMS_JOB compatibility
12:51 - Tuning the Pgpool-II Load balancer
13:50 - Advanced PostgreSQL Features: A Guide
14:51 - [YouTube] TimescaleDB compression by PostgreSQL
15:26 - Daniele Varrazzo
15:39 - Rubber Duck Dev Show Episode 10 | Application Infrastructure - Performance
16:04 - Outro

#postgres #postgresql