Scaling Postgres Episode 180 Aggregate Filters | Insert-Only & Vacuum | Out-of-sync Sequences | Functional Indexes

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.

Content Discussed

• Fast, Flexible Summaries with Aggregate Filters and Windows
• Insert-Only Tables and Autovacuum Issues Prior to PostgreSQL 13
• Fixing out-of-sync sequences in PostgreSQL
• Index Only Scan on Functional Indexes
• PostgreSQL Database Security: OS – Authentication
• How to get advisory lock in shell?
• Announcing PG_DBMS_JOB in PostgreSQL for Oracle DBMS_JOB compatibility
• Tuning the Pgpool-II Load balancer
• Advanced PostgreSQL Features: A Guide
• [YouTube] TimescaleDB compression by PostgreSQL
• Daniele Varrazzo
• Rubber Duck Dev Show Episode 10 | Application Infrastructure Performance