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

In this episode of Scaling Postgres, we discuss how to scale out, how the planner estimates, uses of create statistics and investigating PostgreSQL running environments.

Content Discussed

Preparing your Postgres data for scale-out
Planner selectivity estimation error statistics with pg_qualstats 2
Webinar: All you need to know about CREATE STATISTICS [Follow Up]
[YouTube] PostgreSQL at low level: stay curious!
Researching PostGIS slowness (2019 edition)
Optimizations in GROUP BY vs SELECT DISTINCT
Creating a PostgreSQL procedural language – Part 3 – Executing User Code
PostgreSQL Person of the Week
Parallel Vacuum in Upcoming PostgreSQL 13
On recursive queries
PostGIS Day in STL
Visualizing OSM data in QGIS
Setting up SSL certificate authentication with Pgpool-II
How to use the SVM Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 2)