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

61

April 29, 2019 00:10:15
Constraint Triggers, Simple Shards, Data Streams, OIDs | Scaling Postgres 61

Constraint Triggers, Simple Shards, Data Streams, OIDs | Scaling Postgres 61

In this episode of Scaling Postgres, we review articles covering constraint triggers, simple shards, data streams and OIDs. To get the show notes as...

Listen

60

April 21, 2019 00:14:51
Pluggable Storage, Developer Gotchas, Cursors, PG12 | Scaling Postgres 60

Pluggable Storage, Developer Gotchas, Cursors, PG12 | Scaling Postgres 60

In this episode of Scaling Postgres, we review articles covering pluggable storage, gotchas for developers, using cursors and new PG12 features. To get the...

Listen

59

April 14, 2019 00:12:20
Popularity, Load Testing, Checksums, pg_hba | Scaling Postgres 59

Popularity, Load Testing, Checksums, pg_hba | Scaling Postgres 59

In this episode of Scaling Postgres, we review articles covering Posgres' popularity, conducting load testing, checksums in PG12 and pg_hba configuration. To get the...

Listen

58

April 08, 2019 00:19:00
Security Concerns, Fast Counting, Indexing, Trends | Scaling Postgres 58

Security Concerns, Fast Counting, Indexing, Trends | Scaling Postgres 58

In this episode of Scaling Postgres, we review articles covering security concerns, fast counting tables, indexing basics and PostgreSQL trends. To get the show...

Listen

57

March 31, 2019 00:14:24
Checking Vacuum, Fast Distinct Count, Group By Speed Up, Health Check | Scaling Postgres 57

Checking Vacuum, Fast Distinct Count, Group By Speed Up, Health Check | Scaling Postgres 57

In this episode of Scaling Postgres, we review articles covering checking on vacuum, how to get a fast distinct count and speed up group...

Listen

56

March 24, 2019 00:10:35
Practical Indexing, Vertical Scaling, Partition Migration, FDW Performance | Scaling Postgres 56

Practical Indexing, Vertical Scaling, Partition Migration, FDW Performance | Scaling Postgres 56

In this episode of Scaling Postgres, we review articles covering practical indexing, vertical scalability, migrating to partitions and foreign data wrapper performance. To get...

Listen