Query Planner, BRIN Indexes, Approximate Algorithms, Delayed Replication | Scaling Postgres 53
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
https://www.percona.com/blog/2019/02/21/parallel-queries-in-postgresql/
https://blog.timescale.com/use-relational-database-instead-of-nosql-for-iot-application/
Create your
podcast in
minutes
It is Free