Latest Episodes
71
Indexing Documents, GIN Indexes, Data Science, Generated Columns | Scaling Postgres 71
In this episode of Scaling Postgres, we discuss indexing documents, how GIN indexes work, using Postgres for Data Science and generated columns. To get...
70
Default Security, Max Connections, Progress Reporting, Migration | Scaling Postgres 70
In this episode of Scaling Postgres, we discuss the default security, max_connections and pooling, progress reporting and migrating to Postgres. To get the show...
69
Performance Training, JSON Path, Hypothetical Indexes, Interpolation | Scaling Postgres 69
In this episode of Scaling Postgres, we discuss performance training, SQL/JSON path support, hypothetical indexes and linear interpolation of data. To get the show...
68
Prepared Plans, Materialization, Recursive CTEs, Safe Migrations | Scaling Postgres 68
In this episode of Scaling Postgres, we discuss prepared plans, materialization, recursive CTEs and how to run safe database migrations. To get the show...
67
PGCon, Tips, PostGIS, Strings | Scaling Postgres 67
In this episode of Scaling Postgres, we discuss videos from PGCon, Postgres tips & tricks, PostGIS parallel performance and using strings. To get the...
66
Query Optimization, Normalization, Visualizing Vacuum, Sharding | Scaling Postgres 66
In this episode of Scaling Postgres, we discuss different query optimizations, normalizing to save space, visualizing vacuum and shardings future. To get the show...