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

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://blog.crunchydata.com/blog/fast-flexible-summaries-with-aggregate-filters-and-windows"> https://blog.crunchydata.com/blog/fast-flexible-summaries-with-aggregate-filters-and-windows</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/insert-only-tables-and-autovacuum-issues-prior-to-postgresql-13"> https://blog.crunchydata.com/blog/insert-only-tables-and-autovacuum-issues-prior-to-postgresql-13</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/fixing-out-of-sync-sequences-in-postgresql/"> https://www.cybertec-postgresql.com/en/fixing-out-of-sync-sequences-in-postgresql/</a><br /> <br /> <a href= "https://dev.to/aws-heroes/index-only-scan-on-functional-indexes-9o2"> https://dev.to/aws-heroes/index-only-scan-on-functional-indexes-9o2</a><br /> <br /> <a href= "https://www.percona.com/blog/postgresql-database-security-os-authentication/"> https://www.percona.com/blog/postgresql-database-security-os-authentication/</a><br /> <br /> <a href= "https://www.depesz.com/2021/08/26/how-to-get-advisory-lock-in-shell/"> https://www.depesz.com/2021/08/26/how-to-get-advisory-lock-in-shell/</a><br /> <br /> <a href= "https://www.migops.com/blog/2021/08/27/announcing-pg_dbms_job-in-postgresql-for-oracle-dbms_job-compatibility/"> https://www.migops.com/blog/2021/08/27/announcing-pg_dbms_job-in-postgresql-for-oracle-dbms_job-compatibility/</a><br /> <br /> <a href= "https://www.highgo.ca/2021/08/23/tuning-the-pgpool-ii-load-balancer/"> https://www.highgo.ca/2021/08/23/tuning-the-pgpool-ii-load-balancer/</a><br /> <br /> <a href= "https://arctype.com/blog/postgresql-features-list/">https://arctype.com/blog/postgresql-features-list/</a><br /> <br /> <a href= "https:/