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

34

October 15, 2018 00:11:46
Inserts, Nearest Neighbor, Freezing, Comment | Scaling Postgres 34

Inserts, Nearest Neighbor, Freezing, Comment | Scaling Postgres 34

In this episode of Scaling Postgres, we review articles covering all about inserts, how to handle nearest neighbor, freezing confirmation and Comment. To get...

Listen

33

October 08, 2018 00:09:12
Per-Table Autovacuum, FDW Synchronization, Distinct On | Scaling Postgres 33

Per-Table Autovacuum, FDW Synchronization, Distinct On | Scaling Postgres 33

In this episode of Scaling Postgres, we review articles covering per-table autovacuum, FDW for data synchronization, distinct on and Postgres Open. To get the...

Listen

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