Aggregate Filters, Insert-Only & Vacuum, Out-of-sync Sequences, Functional Indexes | Scaling Postgres 180
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/
Create your
podcast in
minutes
It is Free