Scaling Postgres

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