Podcast Episodes

Timeseries Queries, Arrays, Ranges, C Triggers | Scaling Postgres 77

Episode 77

In this episode of Scaling Postgres, we discuss timeseries queries, using arrays with queries, range use cases and developing triggers in C.

To get the show notes as well as get notified of new episo…

Published on 6 years, 4 months ago

New CVEs, Postgres Programming, JSONB, Advisory Locks | Scaling Postgres 76

Episode 76

In this episode of Scaling Postgres, we discuss new CVEs, programming Postgres, JSONB comparison and using advisory locks.

To get the show notes as well as get notified of new episodes, visit: 

https…

Published on 6 years, 4 months ago

Combining Indexes, Regular Expressions, Parallelism, PostGIS | Scaling Postgres 75

Episode 75

In this episode of Scaling Postgres, we discuss combining indexes, regular expressions, parallelism in Postgres and PostGIS content.

To get the show notes as well as get notified of new episodes, vis…

Published on 6 years, 4 months ago

Picturing Vacuum, Recovery Changes, Cert Authentication, Function Replication | Scaling Postgres 74

Episode 74

In this episode of Scaling Postgres, we discuss vacuum through pictures, upcoming recovery changes, certification authentication and how functions get replicated.

To get the show notes as well as get…

Published on 6 years, 4 months ago

BRIN Indexes, Partition Enhancements, Tips, Standbys | Scaling Postgres 73

Episode 73

In this episode of Scaling Postgres, we discuss BRIN indexes, partition enhancements, general tips and standby scaling.

To get the show notes as well as get notified of new episodes, visit: 

https://…

Published on 6 years, 5 months ago

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

Episode 72

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.

To get the show notes as well as get no…

Published on 6 years, 5 months ago

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

Episode 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 the show notes as well as get notified of new e…

Published on 6 years, 5 months ago

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

Episode 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 notes as well as get notified of new e…

Published on 6 years, 5 months ago

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

Episode 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 notes as well as get notified of ne…

Published on 6 years, 5 months ago

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

Episode 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 notes as well as get notified of new episodes,…

Published on 6 years, 6 months ago