Scaling Postgres Episodes

Episodes on how best to scale your PostgreSQL relational database.

Scaling Postgres Episode 72 | Collation Issues | Fast Loading | Recovery | SCRAM Authentication

In this episode of Scaling Postgres, we discuss collation issues, how to load data quickly, recovery changes in Postgres 12 and moving to SCRAM authentication.

Scaling Postgres Episode 71 | Indexing Documents | GIN Indexes | Data Science | Generated Columns

In this episode of Scaling Postgres, we discuss indexing documents, how GIN indexes work, using Postgres for Data Science and generated columns.

Scaling Postgres Episode 70 | Default Security | Max Connections | Progress Reporting | Migration

In this episode of Scaling Postgres, we discuss the default security, max_connections and pooling, progress reporting and migrating to Postgres.

Scaling Postgres Episode 69 | Performance Training | JSON Path | Hypothetical Indexes | Interpolation

In this episode of Scaling Postgres, we discuss performance training, SQL/JSON path support, hypothetical indexes and linear interpolation of data.

Scaling Postgres Episode 68 | Prepared Plans | Materialization | Recursive CTEs | Safe Migrations

In this episode of Scaling Postgres, we discuss prepared plans, materialization, recursive CTEs and how to run safe database migrations.

Scaling Postgres Episode 67 | PGCon | Tips | PostGIS | Strings

In this episode of Scaling Postgres, we discuss videos from PGCon, Postgres tips & tricks, PostGIS parallel performance and using strings.

Scaling Postgres Episode 66 | Query Optimization | Normalization | Visualizing Vacuum | Sharding

In this episode of Scaling Postgres, we discuss different query optimizations, normalizing to save space, visualizing vacuum and shardings future.

Scaling Postgres Episode 65 | Multi Column | Multi DB | Dos & Don'ts | RUM Indexes

In this episode of Scaling Postgres, we discuss multi-column indexes, using multiple databases, Postgres dos & don'ts as well as using RUM indexes.

Scaling Postgres Episode 64 | Leveraging Indexes | Slugs | Addresses | Security Definer

In this episode of Scaling Postgres, we discuss leveraging indexes, a slug function, addresses and security definer in functions.

Scaling Postgres Episode 63 | Slow Queries | pg_auto_failover | Roles | Hyperscale

In this episode of Scaling Postgres, we review articles covering how to identify slow queries, the pg_auto_failover utility, working with roles and Hyperscale.

Next Page