Scaling Postgres

Planner Optimization, Fish to Elephants, Large Databases, Spatial Data | Scaling Postgres 213

Informações:

Synopsis

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.endpointde