Scaling Postgres

In this episode of Scaling Postgres, we review articles covering the Postgres query planner, BRIN indexes, approximate algorithms, and the uses of delayed replication. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://gocardless.com/blog/debugging-the-postgres-query-planner/ https://info.crunchydata.com/blog/postgresql-brin-indexes-big-data-performance-with-minimal-storage https://www.citusdata.com/blog/2019/02/28/approximation-algorithms-for-your-database/ https://about.gitlab.com/2019/02/13/delayed-replication-for-disaster-recovery-with-postgresql/ https://blog.2ndquadrant.com/achieving-high-availability-postgresql/ https://severalnines.com/blog/current-state-open-source-backup-management-postgresql https://info.crunchydata.com/blog/pgbackrest-performing-backups-on-a-standby-cluster https://www.cybertec-postgresql.com/en/exclusive-backup-deprecated-what-now/ https://rafiasabih.blogspot.com/2019/03/using-parallelism-for-queries-from-pl.html