In this episode of Scaling Postgres, we discuss ways you can optimize the planner, becoming part of the Postgres Community, considerations for large databases and mapping three different types of spatial data.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
- https://www.aha.io/engineering/articles/optimizing-with-the-postgresql-deterministic-query-planner
- https://pganalyze.com/blog/5mins-postgres-tuning-deterministic-query-planner-extended-statistics-join-collapse-limits
- https://www.timescale.com/blog/the-future-of-community-in-light-of-babelfish/
- https://www.percona.com/blog/working-with-large-postgresql-databases/
- https://blog.rustprooflabs.com/2022/04/postgis-h3-intro
- https://selectfrom.dev/mapping-fracking-wells-in-colorado-with-postgresql-db17fc3b8812
- https://www.cybertec-postgresql.com/en/analyzing-historical-flight-data-with-mobilitydb/
- https://www.highgo.ca/2022/04/29/global-deadlock-in-a-distributed-database-cluster/
- https://www.endpointdev.com/blog/2022/04/formatting-sql-vim-pgformat/
- https://www.crunchydata.com/blog/easy-major-postgresql-upgrades-using-pgo-v51
- https://postgresql.life/post/philippe_beaudoin/
- https://www.rubberduckdevshow.com/episodes/40-to-dry-or-not-to-dry/