Scaling Out, Planner Estimation, Create Statistics, Stay Curious | Scaling Postgres 103
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/
Create your
podcast in
minutes
It is Free