|
In this episode of Scaling Postgres, we discuss how to scale out, how the planner estimates, uses of create statistics and investigating PostgreSQL run time environments. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://dev.to/heroku/preparing-your-postgres-data-for-scale-out-km https://rjuju.github.io/postgresql/2020/02/28/pg_qualstats-2-selectivity-error.html https://powa.readthedocs.io/en/latest/components/stats_extensions/pg_qualstats.html https://www.2ndquadrant.com/en/blog/webinar-create-statistics-command-postgresql/ https://www.youtube.com/watch?v=rTIvco34REM https://www.2ndquadrant.com/en/blog/postgis-perf-issue-2019/ https://www.thatguyfromdelhi.com/2020/02/optimizations-in-group-by-vs-select.html https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-3-executing-user-code/ https://postgresql.life/ https://www.highgo.ca/2020/02/28/parallel-vacuum-in-upcoming-postgresql-13/ https://habr.com/en/company/postgrespro/blog/490228/ http://blog.cleverelephant.ca/2020/02/postgis-day-stl.html https://www.cybertec-postgresql.com/en/visualizing-osm-data-in-qgis/ https://www.highgo.ca/2020/02/25/setting-up-ssl-certificate-authentication-with-pgpool-ii/ https://www.2ndquadrant.com/en/blog/how-to-use-the-svm-machine-learning-model-with-2uda-postgresql-and-orange-part-2/ |