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

32

October 01, 2018 00:11:58
Sysadmin Concerns, Power of Indexing, pgbouncer Monitoring | Scaling Postgres 32

Sysadmin Concerns, Power of Indexing, pgbouncer Monitoring | Scaling Postgres 32

In this episode of Scaling Postgres, we review articles covering sysadmin concerns, the power of indexing, pgbouncer monitoring and pg_prewarm. To get the show...

Listen

31

September 24, 2018 00:15:45
CTE Warning, PG 11 Features, Death by DB, Correlation | Scaling Postgres 31

CTE Warning, PG 11 Features, Death by DB, Correlation | Scaling Postgres 31

In this episode of Scaling Postgres, we review articles covering a CTE warning, Postgres 11 new features, death by database and column correlation. To...

Listen

30

September 17, 2018 00:09:45
Parallelism, JIT Compiling, Indexes, Administration | Scaling Postgres 30

Parallelism, JIT Compiling, Indexes, Administration | Scaling Postgres 30

In this episode of Scaling Postgres, we review articles covering parallellism in Postgres 11, JIT compiling, indexes in depth and administration. To get the...

Listen

29

September 10, 2018 00:13:27
Parallel Indexing, SQL vs. ORM, Logical Replication Upgrades | Scaling Postgres 29

Parallel Indexing, SQL vs. ORM, Logical Replication Upgrades | Scaling Postgres 29

In this episode of Scaling Postgres, we review articles covering parallel indexing, SQL vs. ORM, logical replication upgrades and development DBs. To get the...

Listen

28

September 03, 2018 00:17:05
Watch, Fast Text Search, Column Defaults, Import CSVs | Scaling Postgres 28

Watch, Fast Text Search, Column Defaults, Import CSVs | Scaling Postgres 28

In this episode of Scaling Postgres, we review articles covering watching Star Wars, fast text search, column defaults and importing large CSVs. To get...

Listen

27

August 27, 2018 00:18:04
Multiple Databases, Slow Queries, Sorting Performance | Scaling Postgres 27

Multiple Databases, Slow Queries, Sorting Performance | Scaling Postgres 27

In this episode of Scaling Postgres, we review articles covering scaling with multiple databases, detecting slow queries, and sorting performance. To get the show...

Listen