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/postgresql-features-list/

https://www.youtube.com/watch?v=NOpRPzPL1x0

https://postgresql.life/post/daniele_varrazzo/

https://www.rubberduckdevshow.com/episodes/10-application-infrastructure-performance/