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:31

Postgres 14 Beta 1, PG 14 Improvements, Best Primary...

Scaling Postgres ·

2021/05/23

In this episode of Scaling Postgres, we discuss the release of Postgres 14 Beta 1, different PG 14 improvements, choosing the best type of primary key and using composite keys. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/166-postgres-14-beta1-pg14-improvements-best-primary-keys-composite-keys/

en

00:13:33

Postgres Releases, Data Warehouses, Exclusion...

Scaling Postgres ·

2021/05/16

In this episode of Scaling Postgres, we discuss the newest Postgres releases, implementing a data warehouse, using exclusion operators and setting up read-only users. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/165-postgres-releases-data-warehouses-exclusion-operators-read-only-users/

en

00:13:33

Postgres Releases, Data Warehouses, Exclusion...

Scaling Postgres ·

2021/05/16

In this episode of Scaling Postgres, we discuss the newest Postgres releases, implementing a data warehouse, using exclusion operators and setting up read-only users. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/165-postgres-releases-data-warehouses-exclusion-operators-read-only-users/

en

00:17:29

Fast Random Rows, Fast Distinct Queries, Temp &...

Scaling Postgres ·

2021/05/09

In this episode of Scaling Postgres, we discuss selecting random rows quickly, faster distinct queries, how replication handles temp and unlogged tables and how to terminate connections. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/164-fast-random-rows-fast-distinct-queries-temp-unlogged-tables-terminating-connections/

en

00:17:29

Fast Random Rows, Fast Distinct Queries, Temp &...

Scaling Postgres ·

2021/05/09

In this episode of Scaling Postgres, we discuss selecting random rows quickly, faster distinct queries, how replication handles temp and unlogged tables and how to terminate connections. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/164-fast-random-rows-fast-distinct-queries-temp-unlogged-tables-terminating-connections/

en

00:15:42

SQL Data Analysis, pgBouncer Setup, Understanding...

Scaling Postgres ·

2021/05/02

In this episode of Scaling Postgres, we discuss doing data analysis with SQL, sophisticated pgBouncer set ups, understanding how to avoid deadlocks and an intro to tuning and optimization. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/163-sql-data-analysis-pgbouncer-setup-understanding-deadlocks-tuning-optimization/

en

00:15:42

SQL Data Analysis, pgBouncer Setup, Understanding...

Scaling Postgres ·

2021/05/02

In this episode of Scaling Postgres, we discuss doing data analysis with SQL, sophisticated pgBouncer set ups, understanding how to avoid deadlocks and an intro to tuning and optimization. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/163-sql-data-analysis-pgbouncer-setup-understanding-deadlocks-tuning-optimization/

en

00:10:47

Custom Data Types, Row Level Triggers, Dynamic...

Scaling Postgres ·

2021/04/25

In this episode of Scaling Postgres, we discuss implementing row level triggers, how to return dynamic columns using pl/pgsql, and when to use citext. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/162-custom-data-types-row-level-triggers-dynamic-plpgsql-columns-citext-usage/

en

00:10:47

Custom Data Types, Row Level Triggers, Dynamic...

Scaling Postgres ·

2021/04/25

In this episode of Scaling Postgres, we discuss implementing row level triggers, how to return dynamic columns using pl/pgsql, and when to use citext. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/162-custom-data-types-row-level-triggers-dynamic-plpgsql-columns-citext-usage/

en

00:18:11

Scaling Lessons, Synchronous Commit, Connection...

Scaling Postgres ·

2021/04/18

In this episode of Scaling Postgres, we discuss 5 years of scaling lessons, working with synchronous commit, managing connections and cleaning up BLOBs. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/161-scaling-lessons-synchronus-commit-connection-management-blob-cleanup/

en

00:18:11

Scaling Lessons, Synchronous Commit, Connection...

Scaling Postgres ·

2021/04/18

In this episode of Scaling Postgres, we discuss 5 years of scaling lessons, working with synchronous commit, managing connections and cleaning up BLOBs. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/161-scaling-lessons-synchronus-commit-connection-management-blob-cleanup/

en

00:09:09

psql Tips, Postgres 13 Upgrade, Roles Hierarchy,...

Scaling Postgres ·

2021/04/11

In this episode of Scaling Postgres, we discuss tips for using psql, stories from a Postgres 13 upgrade, exploring the role hierarchy and replica scaling considerations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/160-psql-tips-postgres-13-upgrade-roles-hierarchy-replica-scaling/

en

00:09:09

psql Tips, Postgres 13 Upgrade, Roles Hierarchy,...

Scaling Postgres ·

2021/04/11

In this episode of Scaling Postgres, we discuss tips for using psql, stories from a Postgres 13 upgrade, exploring the role hierarchy and replica scaling considerations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/160-psql-tips-postgres-13-upgrade-roles-hierarchy-replica-scaling/

en

00:09:32

Tablespaces, Streaming Replication, More Postgres 14,...

Scaling Postgres ·

2021/04/04

In this episode of Scaling Postgres, we discuss when to use tablespaces, setting up streaming replication, features coming in Postgres 14 and implementing security. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/159-tablespaces-streaming-replication-more-postgres-14-security/

en

00:09:32

Tablespaces, Streaming Replication, More Postgres 14,...

Scaling Postgres ·

2021/04/04

In this episode of Scaling Postgres, we discuss when to use tablespaces, setting up streaming replication, features coming in Postgres 14 and implementing security. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/159-tablespaces-streaming-replication-more-postgres-14-security/

en

00:19:48

Vacuum Speed Up, Faster Foreign Tables, Fast Queries...

Scaling Postgres ·

2021/03/28

In this episode of Scaling Postgres, we discuss a vacuum speed up and faster foreign tables in Postgres 14, running faster queries with union and learning about the query optimizer. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/158-vacuum-speed-up-faster-foreign-tables-fast-queries-with-union-query-optimizer/

en

00:19:48

Vacuum Speed Up, Faster Foreign Tables, Fast Queries...

Scaling Postgres ·

2021/03/28

In this episode of Scaling Postgres, we discuss a vacuum speed up and faster foreign tables in Postgres 14, running faster queries with union and learning about the query optimizer. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/158-vacuum-speed-up-faster-foreign-tables-fast-queries-with-union-query-optimizer/

en

00:18:40

auto_explain Overhead, Postgres Data Lake, Citus...

Scaling Postgres ·

2021/03/22

In this episode of Scaling Postgres, we discuss auto_explain's overhead, setting up a Postgres data lake, rebalancing a Citus shared database and implementing SSL authentication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/157-auto_explain-overhead-postgres-data-lake-citus-shard-rebalance-ssl-authentication/

en

00:18:40

auto_explain Overhead, Postgres Data Lake, Citus...

Scaling Postgres ·

2021/03/22

In this episode of Scaling Postgres, we discuss auto_explain's overhead, setting up a Postgres data lake, rebalancing a Citus shared database and implementing SSL authentication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/157-auto_explain-overhead-postgres-data-lake-citus-shard-rebalance-ssl-authentication/

en

00:16:52

Columnar Storage, Docker Containers, Notify & Listen,...

Scaling Postgres ·

2021/03/15

In this episode of Scaling Postgres, we discuss Citus 10 columnar storage, using Postgres in docker containers, using notify & listen for real-time apps and tuning RHEL. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/156-columnar-storage-docker-containers-notify-listen-tuning-rhel/

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