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:14:01

Observer Effect, Partition Management, Tuple...

Scaling Postgres ·

2020/06/01

In this episode of Scaling Postgres, we discuss the observer effect with explain analyze, partition management, tuple freezing and sources of hung transactions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/116-observer-effect-partition-management-tuple-freezing-hung-transactions/

en

00:12:50

PGCon Online, Performance Tips, Tracking Counts,...

Scaling Postgres ·

2020/05/25

In this episode of Scaling Postgres, we discuss PGCon going online, application performance tips, ways to track counts and essential areas to monitor. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/115-pgcon-online-performance-tips-tracking-counts-essential-monitoring/

en

00:12:50

PGCon Online, Performance Tips, Tracking Counts,...

Scaling Postgres ·

2020/05/25

In this episode of Scaling Postgres, we discuss PGCon going online, application performance tips, ways to track counts and essential areas to monitor. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/115-pgcon-online-performance-tips-tracking-counts-essential-monitoring/

en

00:20:28

Data Directory, Vacuum Features, Binary Performance,...

Scaling Postgres ·

2020/05/18

In this episode of Scaling Postgres, we discuss the Postgres data directory, new vacuum features, binary storage performance and the impact of network latency. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/114-data-directory-vacuum-features-binary-performance-network-latency/

en

00:20:28

Data Directory, Vacuum Features, Binary Performance,...

Scaling Postgres ·

2020/05/18

In this episode of Scaling Postgres, we discuss the Postgres data directory, new vacuum features, binary storage performance and the impact of network latency. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/114-data-directory-vacuum-features-binary-performance-network-latency/

en

00:13:06

arm64 with apt, Contributors, Backup Manifest, Now...

Scaling Postgres ·

2020/05/11

In this episode of Scaling Postgres, we discuss arm64 package support for apt, annual Postgres contributors, backup manifests & verifications and different now functions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/113-arm64-with-apt-contributors-backup-manifest-now-functions/

en

00:13:06

arm64 with apt, Contributors, Backup Manifest, Now...

Scaling Postgres ·

2020/05/11

In this episode of Scaling Postgres, we discuss arm64 package support for apt, annual Postgres contributors, backup manifests & verifications and different now functions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/113-arm64-with-apt-contributors-backup-manifest-now-functions/

en

00:16:44

Explain Analyze, Sequence Counts, Best Books,...

Scaling Postgres ·

2020/05/04

In this episode of Scaling Postgres, we discuss how to use explain analyze, the problem with counting sequences, the best books to learn Postgres and how to migrate to declarative partitioning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/112-explain-analyze-sequence-counts-best-books-partition-migration/

en

00:16:44

Explain Analyze, Sequence Counts, Best Books,...

Scaling Postgres ·

2020/05/04

In this episode of Scaling Postgres, we discuss how to use explain analyze, the problem with counting sequences, the best books to learn Postgres and how to migrate to declarative partitioning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/112-explain-analyze-sequence-counts-best-books-partition-migration/

en

00:16:48

Insert-Only Vacuum, Settings, Sequence Replication,...

Scaling Postgres ·

2020/04/26

In this episode of Scaling Postgres, we discuss insert-only vacuums, the Postgres settings hierarchy, sequence replication and desired improvements. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/111-insert-only-vacuum-settings-sequence-replication-improvements/

en

00:16:48

Insert-Only Vacuum, Settings, Sequence Replication,...

Scaling Postgres ·

2020/04/26

In this episode of Scaling Postgres, we discuss insert-only vacuums, the Postgres settings hierarchy, sequence replication and desired improvements. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/111-insert-only-vacuum-settings-sequence-replication-improvements/

en

00:13:33

Max Connections, SQL Tricks, Fast Text Search,...

Scaling Postgres ·

2020/04/20

In this episode of Scaling Postgres, we discuss tuning max connections, different SQL tricks, setting up fast text search and handling security & compliance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/110-max-connections-sql-tricks-fast-text-search-security-compliance/

en

00:13:33

Max Connections, SQL Tricks, Fast Text Search,...

Scaling Postgres ·

2020/04/20

In this episode of Scaling Postgres, we discuss tuning max connections, different SQL tricks, setting up fast text search and handling security & compliance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/110-max-connections-sql-tricks-fast-text-search-security-compliance/

en

00:12:35

Show Plans, WAL Monitoring, Using UUIDs, Default...

Scaling Postgres ·

2020/04/13

In this episode of Scaling Postgres, we discuss how to show live plans, how Postgres 13 allows WAL monitoring, how to use UUIDs in your app and how logging is setup by default. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/109-show-plans-wal-monitoring-using-uuids-default-logging/

en

00:12:35

Show Plans, WAL Monitoring, Using UUIDs, Default...

Scaling Postgres ·

2020/04/13

In this episode of Scaling Postgres, we discuss how to show live plans, how Postgres 13 allows WAL monitoring, how to use UUIDs in your app and how logging is setup by default. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/109-show-plans-wal-monitoring-using-uuids-default-logging/

en

00:20:43

Ten Things, Audit Triggers, Schema Design, High...

Scaling Postgres ·

2020/04/06

In this episode of Scaling Postgres, we discuss ten things to hate about Postgres, audit trigger performance, designing a schema and the future of high availability. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/108-ten-things-audit-triggers-schema-design-high-availability/

en

00:20:43

Ten Things, Audit Triggers, Schema Design, High...

Scaling Postgres ·

2020/04/06

In this episode of Scaling Postgres, we discuss ten things to hate about Postgres, audit trigger performance, designing a schema and the future of high availability. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/108-ten-things-audit-triggers-schema-design-high-availability/

en

00:10:48

Showing Plans, Atomic, Configuration, Migrations |...

Scaling Postgres ·

2020/03/30

In this episode of Scaling Postgres, we discuss how to show live query plans, the importance of atomic operations for scaling out, configuration options and DBaaS migrations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/107-showing-plans-atomic-configuration-migrations/

en

00:10:48

Showing Plans, Atomic, Configuration, Migrations |...

Scaling Postgres ·

2020/03/30

In this episode of Scaling Postgres, we discuss how to show live query plans, the importance of atomic operations for scaling out, configuration options and DBaaS migrations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/107-showing-plans-atomic-configuration-migrations/

en

00:14:58

Recursive CTEs, DB Access Patterns, Dates & Times,...

Scaling Postgres ·

2020/03/23

In this episode of Scaling Postgres, we discuss how to use recursive CTEs, database access patterns, using dates and times and how to cluster your data. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/106-recursive-cte-db-access-patterns-dates-times-cluster/

en

791 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