Podcast Episodes

pg_receivewal, Application Failover, pg_checksums, pgBouncer | Scaling Postgres 87

Episode 87

In this episode of Scaling Postgres, we discuss the benefits of pg_receivewal, how to setup simple application failover, new pg_checksums and setting up pgBouncer.

To get the show notes as well as ge…

Published on 6 years, 1 month ago

Prewarming, Nondeterministic Collations, Generated Column Performance, Foreign Keys | Scaling Postgres 86

Episode 86

In this episode of Scaling Postgres, we discuss prewarming your cache, working with nondeterministic collations, generated column performance and foreign keys with partitions.

To get the show notes a…

Published on 6 years, 2 months ago

Recovery Configuration, Alter System, Transaction Isolation, Temp Table Vacuum | Scaling Postgres 85

Episode 85

In this episode of Scaling Postgres, we discuss changes to recovery configuration, the alter system command, transaction isolation and vacuum for temp tables.

To get the show notes as well as get not…

Published on 6 years, 2 months ago

Postgres 12 Released, Generated Columns, Parallel Estimates, Change Data Capture | Scaling Postgres 84

Episode 84

In this episode of Scaling Postgres, we discuss the release features of Postgres 12, generated columns, parallel estimates and change data capture.

To get the show notes as well as get notified of ne…

Published on 6 years, 2 months ago

Postgres 12, Window Frames, Index Types, Synchronous Replication | Scaling Postgres 83

Episode 83

In this episode of Scaling Postgres, we discuss the release of Postgres 12, how to use window frames, the different index types, and when to use synchronous replication.

To get the show notes as well…

Published on 6 years, 2 months ago

Faster Partitions, Count Speed, Extensions, Education | Scaling Postgres 82

Episode 82

In this episode of Scaling Postgres, we discuss faster partition performance, count speed, extensions and Postgres education.

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

ht…

Published on 6 years, 2 months ago

Data Loading Speed, View Dependencies, Users & Roles, H/A Clusters | Scaling Postgres 81

Episode 81

In this episode of Scaling Postgres, we discuss data loading speeds, view dependencies, users & roles and high availability clusters.

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

Published on 6 years, 3 months ago

Just Upgrade, Vacuum Updates, Connection Strings, Postgres Showcase | Scaling Postgres 80

Episode 80

In this episode of Scaling Postgres, we discuss why you should just upgrade, vacuum updates in Postgres 12, psql connection strings and a Postgres showcase.

To get the show notes as well as get notif…

Published on 6 years, 3 months ago

PgBouncer SCRAM, Art of PostgreSQL, Distributed Time-Series, Window Functions | Scaling Postgres 79

Episode 79

In this episode of Scaling Postgres, we discuss PgBouncer SCRAM support, The Art of PostgreSQL, making Postgres a distributed time-series DB and window functions.

To get the show notes as well as get…

Published on 6 years, 3 months ago

Efficient Pagination, Rotating Passwords, BRIN, Row Level Security | Scaling Postgres 78

Episode 78

In this episode of Scaling Postgres, we discuss efficient pagination, how to rotate passwords, BRIN benefits and Row Level Security.

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

Published on 6 years, 3 months ago