Episode 103 Scaling Out | Planner Estimation | Create Statistics | Stay Curious

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://dev.to/heroku/preparing-your-postgres-data-for-scale-out-km"> https://dev.to/heroku/preparing-your-postgres-data-for-scale-out-km</a></p> <p><a href= "https://rjuju.github.io/postgresql/2020/02/28/pg_qualstats-2-selectivity-error.html"> https://rjuju.github.io/postgresql/2020/02/28/pg_qualstats-2-selectivity-error.html</a></p> <p><a href= "https://powa.readthedocs.io/en/latest/components/stats_extensions/pg_qualstats.html"> https://powa.readthedocs.io/en/latest/components/stats_extensions/pg_qualstats.html</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/webinar-create-statistics-command-postgresql/"> https://www.2ndquadrant.com/en/blog/webinar-create-statistics-command-postgresql/</a></p> <p><a href= "https://www.youtube.com/watch?v=rTIvco34REM">https://www.youtube.com/watch?v=rTIvco34REM</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/postgis-perf-issue-2019/">https://www.2ndquadrant.com/en/blog/postgis-perf-issue-2019/</a></p> <p><a href= "https://www.thatguyfromdelhi.com/2020/02/optimizations-in-group-by-vs-select.html"> https://www.thatguyfromdelhi.com/2020/02/optimizations-in-group-by-vs-select.html</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-3-executing-user-code/"> https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-3-executing-user-code/</a></p> <p><a href= "https://postgresql.life/">https://postgresql.life/</a></p> <p><a href= "https://www.highgo.ca/2020/02/28/parallel-vacuum-in-upcoming-postgresql-13/"> https://www.highgo.ca/2020/02/28/parallel-vacuum-in-upcoming-postgresql-13/</a></p> <p><a href= "https://habr.com/en/company/postgrespro/blog/490228/">https://habr.com/en/company/postgres