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:11:38

Reduce Replication Lag, Explain Parameterized Query,...

Scaling Postgres ·

2022/11/21

In this episode of Scaling Postgres, we discuss how PG15 helps reduce replication lag, how to get the parameters used in prepared statements, PostGIS Day and how to use multiple pgbouncers. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/242-reduce-replication-lag-explain-parameterized-query-postgis-day-multiple-pgbouncers/

en

00:17:53

Postgres 15.1, Postres 10 Retrospective, Reducing...

Scaling Postgres ·

2022/11/13

In this episode of Scaling Postgres, we discuss the release of Postgres 15.1, a Postgres 10 retrospective, how to reduce replication lag and using listen & notify. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/241-postgres-15.1-postgres-10-retrospective-reducing-replication-lag-listen-notify/

en

00:17:53

Postgres 15.1, Postres 10 Retrospective, Reducing...

Scaling Postgres ·

2022/11/13

In this episode of Scaling Postgres, we discuss the release of Postgres 15.1, a Postgres 10 retrospective, how to reduce replication lag and using listen & notify. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/241-postgres-15.1-postgres-10-retrospective-reducing-replication-lag-listen-notify/

en

00:19:17

Forced Sequential Scans, Table Renaming, Terminology,...

Scaling Postgres ·

2022/11/06

In this episode of Scaling Postgres, we discuss how sequential scans can be forced, the best way to rename a table without downtime, different Postgres terminology and the PGSQL Phriday blogging event. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/240-forced-sequential-scans-table-renaming-terminology-pgsql-phriday/

en

00:19:17

Forced Sequential Scans, Table Renaming, Terminology,...

Scaling Postgres ·

2022/11/06

In this episode of Scaling Postgres, we discuss how sequential scans can be forced, the best way to rename a table without downtime, different Postgres terminology and the PGSQL Phriday blogging event. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/240-forced-sequential-scans-table-renaming-terminology-pgsql-phriday/

en

00:15:18

Shared Buffers, Compression Algorithm, Merge Command,...

Scaling Postgres ·

2022/10/30

In this episode of Scaling Postgres, we discuss how to set shared buffers, the different WAL compression algorithm options, how to use the merge command and how to contribute to Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/239-shared-buffers-compression-algorithms-merge-command-postgres-contributions/

en

00:15:18

Shared Buffers, Compression Algorithm, Merge Command,...

Scaling Postgres ·

2022/10/30

In this episode of Scaling Postgres, we discuss how to set shared buffers, the different WAL compression algorithm options, how to use the merge command and how to contribute to Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/239-shared-buffers-compression-algorithms-merge-command-postgres-contributions/

en

00:13:05

Slow Updates, Lateral Joins, Serial To Identity, PG...

Scaling Postgres ·

2022/10/24

In this episode of Scaling Postgres, we discuss why and what to do when updates are slow, use cases for lateral joins, moving from serial to identity for auto-incrementing ids and changes to Postgres 15. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/238-slow-updates-lateral-joins-serial-to-identity-pg15-changes/

en

00:13:05

Slow Updates, Lateral Joins, Serial To Identity, PG...

Scaling Postgres ·

2022/10/24

In this episode of Scaling Postgres, we discuss why and what to do when updates are slow, use cases for lateral joins, moving from serial to identity for auto-incrementing ids and changes to Postgres 15. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/238-slow-updates-lateral-joins-serial-to-identity-pg15-changes/

en

00:18:53

Postgres 15 Released, File Systems, Connection...

Scaling Postgres ·

2022/10/16

In this episode of Scaling Postgres, we discuss the release of Postgres 15, the performance of different file systems with Postgres, options for connection pooling and how to secure your connections. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/237-postgres-15-released-file-systems-connection-pooling-secure-connections/

en

00:18:53

Postgres 15 Released, File Systems, Connection...

Scaling Postgres ·

2022/10/16

In this episode of Scaling Postgres, we discuss the release of Postgres 15, the performance of different file systems with Postgres, options for connection pooling and how to secure your connections. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/237-postgres-15-released-file-systems-connection-pooling-secure-connections/

en

00:19:54

Postgres 15 RC2, Shared Buffers, Secure Connections,...

Scaling Postgres ·

2022/10/10

In this episode of Scaling Postgres, we discuss the Postgres 15 RC2, optimizing shared buffers, how to secure your database connections and blog posts from PGSQL Phriday. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/236-postgres-15-rc2-shared-buffers-secure-connections-pgsql-phriday/

en

00:19:54

Postgres 15 RC2, Shared Buffers, Secure Connections,...

Scaling Postgres ·

2022/10/10

In this episode of Scaling Postgres, we discuss the Postgres 15 RC2, optimizing shared buffers, how to secure your database connections and blog posts from PGSQL Phriday. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/236-postgres-15-rc2-shared-buffers-secure-connections-pgsql-phriday/

en

00:16:21

Postgres 15 RC1, ICU Collations, Listen & Notify,...

Scaling Postgres ·

2022/10/03

In this episode of Scaling Postgres, we discuss the release of the Postgres 15 Release Candidate 1, new ICU collations features, how to use listen & notify and understanding TOAST. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/235-postgres-15-rc1-icu-collations-listen-notify-understanding-toast/

en

00:16:21

Postgres 15 RC1, ICU Collations, Listen & Notify,...

Scaling Postgres ·

2022/10/03

In this episode of Scaling Postgres, we discuss the release of the Postgres 15 Release Candidate 1, new ICU collations features, how to use listen & notify and understanding TOAST. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/235-postgres-15-rc1-icu-collations-listen-notify-understanding-toast/

en

00:16:20

Rust for Extensions, Timescale vs. Postgres,...

Scaling Postgres ·

2022/09/25

In this episode of Scaling Postgres, we discuss using rust for Postgres extensions, performance comparisons of TimescaleDB vs. Postgres, uninterrupted writes when sharding in Citus and the Postgres data flow. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/234-rust-for-extensions-timescale-vs-postgres-uninterrupted-sharding-data-flow/

en

00:16:20

Rust for Extensions, Timescale vs. Postgres,...

Scaling Postgres ·

2022/09/25

In this episode of Scaling Postgres, we discuss using rust for Postgres extensions, performance comparisons of TimescaleDB vs. Postgres, uninterrupted writes when sharding in Citus and the Postgres data flow. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/234-rust-for-extensions-timescale-vs-postgres-uninterrupted-sharding-data-flow/

en

00:13:43

Useful Features, Community Blogging, PG 15...

Scaling Postgres ·

2022/09/18

In this episode of Scaling Postgres, we discuss little known useful features, a monthly community blogging initiative, PG 15 Anticipation, and getting generic plans. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/233-useful-features-community-blogging-pg15-anticipation-generic-plans/

en

00:13:43

Useful Features, Community Blogging, PG 15...

Scaling Postgres ·

2022/09/18

In this episode of Scaling Postgres, we discuss little known useful features, a monthly community blogging initiative, PG 15 Anticipation, and getting generic plans. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/233-useful-features-community-blogging-pg15-anticipation-generic-plans/

en

00:14:36

PG15 Beta 4, Primary Key Options, Sequence Limits,...

Scaling Postgres ·

2022/09/12

In this episode of Scaling Postgres, we discuss the release of Postgres 15 Beta 4, different primary key options, sequence limits and how to examine your Postgres configuration. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/232-pg15-beta-4-primary-key-options-sequence-limits-configuration/

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