Scaling Postgres

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 ...more

Hosted by

Latest Episodes

18

June 25, 2018 00:17:31
Impact of Virtualization, Compressing Data, Parallelism | Scaling Postgres 18

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...

Listen

17

June 18, 2018 00:19:40
Real Time Analytics, Index Decrease Performance, work_mem | Scaling Postgres 17

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...

Listen

16

June 11, 2018 00:11:57
Storing Bits, Autovacuum, Assertions, Logical Recovery | Scaling Postgres 16

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...

Listen

15

June 04, 2018 00:12:02
Leveraging Postgres, Tuning Autovacuum, Slow Queries | Scaling Postgres 15

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....

Listen

14

May 28, 2018 00:13:04
Postgres 11, Multi-tenant Scale, Trigger Speed, Full Text Search | Scaling Postgres 14

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...

Listen

13

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

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...

Listen