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/