x

75% of people globally want unbiased news (Pew Research) but are concerned they're not getting that.

Get balanced coverage with Symby. See how stories are covered across diverse outlets and spot when one side covers a story the other skips.

PODCAST

Scaling Postgres

Creston Jamison

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 your architecture and usage is the key to getting the most performance out of PostgreSQL.

technology

All Episodes

00:16:28

5 Times Faster Aggregates | Scaling Postgres 394

Scaling Postgres ·

2025/11/30

In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases and why you should hard your datbase. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/394-five-times-faster-aggregates/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:14:41

Job Security? | Scaling Postgres 393

Scaling Postgres ·

2025/11/23

In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases and why you should hard your datbase. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/393-job-security/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:14:41

Job Security? | Scaling Postgres 393

Scaling Postgres ·

2025/11/23

In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases and why you should shard your database. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/393-job-security/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:15:52

100 Times Faster By Skipping! | Scaling Postgres 392

Scaling Postgres ·

2025/11/16

In this episode of Scaling Postgres, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal indexes and more details about my upcoming course discount. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/392-100-times-faster-by-skipping/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified

en

00:19:15

Table Lock Explosion! | Scaling Postgres 391

Scaling Postgres ·

2025/11/09

In this episode of Scaling Postgres, we discuss the issues of partition locking during planning, the problem of too much memory, the importance of a txvector column and an upcoming sale on my course. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/391-table-lock-explosion/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:19:15

Table Lock Explosion! | Scaling Postgres 391

Scaling Postgres ·

2025/11/09

In this episode of Scaling Postgres, we discuss the issues of partition locking during planning, the problem of too much memory, the importance of a txvector column and an upcoming sale on my course. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/391-table-lock-explosion/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:17:32

1.2 Million Messages Per Second | Scaling Postgres 390

Scaling Postgres ·

2025/11/02

In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and nested partitioning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/390-1.2-million-messages-per-second/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:17:32

1.2 Million Messages Per Second | Scaling Postgres 390

Scaling Postgres ·

2025/11/02

In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and nested partitioning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/390-1.2-million-messages-per-second/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:14:21

Heavy Reader or Writer? | Scaling Postgres 389

Scaling Postgres ·

2025/10/26

In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightweight locks and a backup public service announcement. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/389-heavy-reader-or-writer/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:14:21

Heavy Reader or Writer? | Scaling Postgres 389

Scaling Postgres ·

2025/10/26

In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightweight locks and a backup public service announcement. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/389-heavy-reader-or-writer/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:16:26

NVME Wins? | Scaling Postgres 388

Scaling Postgres ·

2025/10/19

In this episode of Scaling Postgres, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and can a faster software & hardware environment cause performance problems? To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/388-nvme-wins/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:16:26

NVME Wins? | Scaling Postgres 388

Scaling Postgres ·

2025/10/19

In this episode of Scaling Postgres, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and can a faster software & hardware environment cause performance problems? To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/388-nvme-wins/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:15:54

Boosting Planning Performance | Scaling Postgres 387

Scaling Postgres ·

2025/10/12

In this episode of Scaling Postgres, we explore how PG18 locking changes can boost planning performance, how to store data safely on a budget, how to build a parquet file archive solution and we discuss the completion of the summer of upgrades. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/387-boosting-planning-performance/ Want to learn more about Postgres performance? Join my FREE training

en

00:15:54

Boosting Planning Performance | Scaling Postgres 387

Scaling Postgres ·

2025/10/12

In this episode of Scaling Postgres, we explore how PG18 locking changes can boost planning performance, how to store data safely on a budget, how to build a parquet file archive solution and we discuss the completion of the summer of upgrades. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/387-boosting-planning-performance/ Want to learn more about Postgres performance? Join my FREE training

en

00:15:03

Postgres 18: The Deep Cuts | Scaling Postgres 386

Scaling Postgres ·

2025/10/05

In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with limit and how recent Ubuntu OS patches cause a Postgres restart. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/386-postgres-18-the-deep-cuts/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified

en

00:15:03

Postgres 18: The Deep Cuts | Scaling Postgres 386

Scaling Postgres ·

2025/10/05

In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with limit and how recent Ubuntu OS patches cause a Postgres restart. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/386-postgres-18-the-deep-cuts/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified

en

00:17:07

Postgres 18 Released! | Scaling Postgres 385

Scaling Postgres ·

2025/09/28

In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced return from statements, parallel apply, adding not null as not valid and more! To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/385-postgres-18-released/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance

en

00:17:07

Postgres 18 Released! | Scaling Postgres 385

Scaling Postgres ·

2025/09/28

In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced return from statements, parallel apply, adding not null as not valid and more! To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/385-postgres-18-released/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance

en

00:17:25

Preparing For Postgres 18 | Scaling Postgres 384

Scaling Postgres ·

2025/09/21

In this episode of Scaling Postgres, we discuss getting excited about Postgres 18, oauth authentication, reconsidering your interface and a zero downtime upgrade. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/384-preparing-for-postgres-18/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:17:25

Preparing For Postgres 18 | Scaling Postgres 384

Scaling Postgres ·

2025/09/21

In this episode of Scaling Postgres, we discuss getting excited about Postgres 18, oauth authentication, reconsidering your interface and a zero downtime upgrade. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/384-preparing-for-postgres-18/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

763 results

Similar Podcasts

Lead With AI

Tamara Nall

Linux in the Ham Shack

Black Sparrow Media

Data Engineering Podcast

Tobias Macey

Eye On A.I.

Craig S. Smith

Reflections

Livewire Labs