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

106

March 23, 2020 00:14:58
Recursive CTEs, DB Access Patterns, Dates & Times, Cluster | Scaling Postgres 106

Recursive CTEs, DB Access Patterns, Dates & Times, Cluster | Scaling Postgres 106

In this episode of Scaling Postgres, we discuss how to use recursive CTEs, database access patterns, using dates and times and how to cluster...

Listen

105

March 16, 2020 00:19:22
World's Best, Subtransactions, Sharding, Schema Changes | Scaling Postgres 105

World's Best, Subtransactions, Sharding, Schema Changes | Scaling Postgres 105

In this episode of Scaling Postgres, we discuss how Postgres is the world's best database, performance ramifications of subtransactions, the current state of sharding...

Listen

104

March 09, 2020 00:15:21
Reducing WAL, What is Null?, Understanding SQL, TPC-H Benchmarking | Scaling Postgres 104

Reducing WAL, What is Null?, Understanding SQL, TPC-H Benchmarking | Scaling Postgres 104

In this episode of Scaling Postgres, we discuss how to reduce the size of your WAL files, what is null, how to better understand...

Listen

103

March 02, 2020 00:13:57
Scaling Out, Planner Estimation, Create Statistics, Stay Curious | Scaling Postgres 103

Scaling Out, Planner Estimation, Create Statistics, Stay Curious | Scaling Postgres 103

In this episode of Scaling Postgres, we discuss how to scale out, how the planner estimates, uses of create statistics and investigating PostgreSQL run...

Listen

102

February 24, 2020 00:12:44
UUID Use Cases, pg_settings, Automated Restore, Parallel Future | Scaling Postgres 102

UUID Use Cases, pg_settings, Automated Restore, Parallel Future | Scaling Postgres 102

In this episode of Scaling Postgres, we discuss the use cases for UUIDs, using pg_settings, setting up an automated restore and the future of...

Listen

101

February 17, 2020 00:17:46
Postgres Releases, Useless Vacuum, Isolation Differences, WAL Compression | Scaling Postgres 101

Postgres Releases, Useless Vacuum, Isolation Differences, WAL Compression | Scaling Postgres 101

In this episode of Scaling Postgres, we discuss new postgres releases, useless vacuuming, isolation differences between databases, and different ways to compress WAL files....

Listen