Latest Episodes
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...
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...
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...
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...
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....
78
Efficient Pagination, Rotating Passwords, BRIN, Row Level Security | Scaling Postgres 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...