Creston Jamison

Scaling Postgres

Technology EN ↓ 439 avsnitt

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.

Glöm inte att besöka poddens webbplats och stötta skaparen: www.scalingpostgres.com

Skapare

Creston Jamison

Kategori

Technology

Poddens webbplats

www.scalingpostgres.com

Senaste avsnittet

18 okt 2026

Var kan du lyssna?

Poddar i appen Replaio Radio Kommer snart

Poddar kommer snart till appen. Installera nu och bli först med att uppleva ett helt nytt sätt att lyssna på poddar

Installera gratis Android nästan 10 mn nedladdningar · betyg 4,8 iOS snart

Avsnitt

Postgres 11, Multi-tenant Scale, Trigger Speed, Full Text Search | Scaling Postgres 14 28.05.2018 13:04

In this episode of Scaling Postgres, we review articles covering the upcoming PostgreSQL 11, scaling for multi-tenant apps, the speed of triggers and full text search. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/14-pg11-multi-tenant-scale-trigger-speed-full-text-search/

Sharding Future, Query Optimization, Replication Read Performance, PostGIS | Scaling Postgres 13 21.05.2018 16:00

In this episode of Scaling Postgres, we review articles covering the future of sharding PostgreSQL databases, query optimization, replication read performance and PostGIS. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/13-shardings-future-query-optimization-replication-read-performance-postgis/

The Future, Slow Counts, Avoid Or, Replication | Scaling Postgres 12 14.05.2018 11:12

In this episode of Scaling Postgres, we review articles covering the future of databases, why counting is slow, the best ways to avoid ORs, and all about replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/12-future-slow-counts-avoid-or-replication/

Serializable, JSON & JSONB, Fast Data Loading, PG11 Features | Scaling Postgres 11 07.05.2018 12:13

In this episode of Scaling Postgres, we review articles covering serializable, JSON & JSONB data types, fast data loading with Ruby and Postgres 11 new features. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/11-serializable-json-jsonb-fast-data-loading-pg11-features/

ANSI Schmansi, Split-Brain, Performance Scenarios, Parallelism | Scaling Postgres 10 30.04.2018 12:12

In this episode of Scaling Postgres, we review articles covering ANSI Schmansi, split-brain replication issues, performance solutions to business scenarios and paralellism. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/10-ansi-schmansi-split-brain-performance-scenarios-parallelism/

High Volume Processing, pg_wal Issues, Restore with pg_receivewal | Scaling Postgres 9 23.04.2018 11:01

In this episode of Scaling Postgres, we review articles covering high volume processing, indexing, pg_wal issues, Postgres data types and restoring when using pg_receivewal. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/9-high-volume-processing-pg_wal-issues-restore-pg_receivewal/

Scaling Real-Time Analytics, Covering Indexes, 1,500 Upgrades | Scaling Postgres 8 16.04.2018 15:06

In this episode of Scaling Postgres, we review articles covering real-time analytics at scale, covering indexes in Postgres 11, 1,500 Postgres upgrades and PostgreSQL vs. MySQL. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/8-scaling-analytics-covering-indexes-1500-upgrades/

Any Scale, Monitoring Vacuum, Copy, Annotated Config | Scaling Postgres 7 09.04.2018 11:09

In this episode of Scaling Postgres, we review articles covering Postgres at any scale, monitoring vacuum, using copy, annotated config files, and how to do easy replication failback to an old primary database. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/7-any-scale-monitor-vacuum-copy-annotated-config/

Terabyte Scale, Permissions, Fast Column Adds, pgBouncer | Scaling Postgres 6 02.04.2018 10:42

In this episode of Scaling Postgres, we review articles covering terabyte scale & analytics, database permissions, fast column adding coming to PosgreSQL 11 and pgBouncer. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/6-terabyte-scale-permissions-fast-column-add-pgbouncer/

Constraints, User Order, PG Terrible, Logical Upgrades | Scaling Postgres 5 26.03.2018 14:44

In this episode of Scaling Postgres, we review articles covering database constraints, user defined ordering, how PostgreSQL is terrible, TimeScaleDB and using logical replication for upgrades. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/5-constraints-user-order-pg-terrible-logical-upgrades/

50TB Upgrade, Vacuum, DB Security | Scaling Postgres 4 19.03.2018 12:27

In this episode of Scaling Postgres, we review articles covering developers loving PostgreSQL, a 50TB database upgrade, information on vacuums, patches for parallel PostGIS plans, database security concerns, DB normalization and primary keys and generate series. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/4-50TB-upgrade-vacuum-db-...

Modeling, Query Performance, Statistics, pgmetrics | Scaling Postgres 3 12.03.2018 9:02

In this episode of Scaling Postgres, we review articles covering modeling, checking for long queries using pg_stat_statements, statistics in PosgreSQL 10 and pgmetrics. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/3-modeling-query-performance-statistics-pgmetrics/

Analytical DBs, Recursive Queries, Replication | Scaling Postgres 2 05.03.2018 17:38

In this episode of Scaling Postgres, we review articles covering analytical DBs (potentially using GPUs), recursive queries and different forms of replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/2-analytical-db-recursive-queries-replication/

Petabyte Scale and Locking | Scaling Postgres 1 27.02.2018 17:44

In this episode of Scaling Postgres, we review articles covering petabyte scale techniques as well as various articles on locking. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/1-petabyte-scale-and-locking/