Scaling Postgres

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since ...more

Hosted by

Latest Episodes

84

October 07, 2019 00:12:37
Postgres 12 Released, Generated Columns, Parallel Estimates, Change Data Capture | Scaling Postgres 84

Postgres 12 Released, Generated Columns, Parallel Estimates, Change Data Capture | Scaling Postgres 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...

Listen

83

September 30, 2019 00:13:14
Postgres 12, Window Frames, Index Types, Synchronous Replication | Scaling Postgres 83

Postgres 12, Window Frames, Index Types, Synchronous Replication | Scaling Postgres 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...

Listen

82

September 23, 2019 00:12:56
Faster Partitions, Count Speed, Extensions, Education | Scaling Postgres 82

Faster Partitions, Count Speed, Extensions, Education | Scaling Postgres 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...

Listen

81

September 16, 2019 00:12:44
Data Loading Speed, View Dependencies, Users & Roles, H/A Clusters | Scaling Postgres 81

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

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

Listen

80

September 09, 2019 00:13:47
Just Upgrade, Vacuum Updates, Connection Strings, Postgres Showcase | Scaling Postgres 80

Just Upgrade, Vacuum Updates, Connection Strings, Postgres Showcase | Scaling Postgres 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...

Listen

79

September 02, 2019 00:10:06
PgBouncer SCRAM, Art of PostgreSQL, Distributed Time-Series, Window Functions | Scaling Postgres 79

PgBouncer SCRAM, Art of PostgreSQL, Distributed Time-Series, Window Functions | Scaling Postgres 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....

Listen