Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

June 25, 2018 Impact of Virtualization, Compressing Data, Parallelism | Scaling Postgres 18
In this episode of Scaling Postgres, we review articles covering the impact of virtualization on databases, techniques to compress your data and parallelism.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/18-impact-virtualization-compressing-data-parallelism/
18 min
June 18, 2018 Real Time Analytics, Index Decrease Performance, work_mem | Scaling Postgres 17
In this episode of Scaling Postgres, we review articles covering using Postgres for real-time analytics, how indexes can decrease performance and how to configure work_mem.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/17-real-time-analytics-index-decrease-performance-work_mem/
20 min
June 11, 2018 Storing Bits, Autovacuum, Assertions, Logical Recovery | Scaling Postgres 16
In this episode of Scaling Postgres, we review articles covering efficiently storing bits, autovacuum, setting up assertions and logical replication recovery.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/16-storing-bits-autovacuum-assertions-logical-recovery/
12 min
June 04, 2018 Leveraging Postgres, Tuning Autovacuum, Slow Queries | Scaling Postgres 15
In this episode of Scaling Postgres, we review articles on how to better leverage postgres, tuning autovacuum, handling slow queries and using window functions.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/15-leveraging-postgres-tuning-autovacuum-slow-queries/
13 min
May 28, 2018 Postgres 11, Multi-tenant Scale, Trigger Speed, Full Text Search | Scaling Postgres 14
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/
14 min
May 21, 2018 Sharding Future, Query Optimization, Replication Read Performance, PostGIS | Scaling Postgres 13
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/
16 min
May 14, 2018 The Future, Slow Counts, Avoid Or, Replication | Scaling Postgres 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/
12 min
May 07, 2018 Serializable, JSON & JSONB, Fast Data Loading, PG11 Features | Scaling Postgres 11
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/
13 min
April 30, 2018 ANSI Schmansi, Split-Brain, Performance Scenarios, Parallelism | Scaling Postgres 10
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/
13 min
April 23, 2018 High Volume Processing, pg_wal Issues, Restore with pg_receivewal | Scaling Postgres 9
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/
12 min

About Scaling Postgres

From the publisher's feed

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…