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

63

May 12, 2019 00:12:07
Slow Queries, pg_auto_failover, Roles, Hyperscale | Scaling Postgres 63

Slow Queries, pg_auto_failover, Roles, Hyperscale | Scaling Postgres 63

In this episode of Scaling Postgres, we review articles covering how to identify slow queries, the pg_auto_failover utility, working with roles and Hyperscale. To...

Listen

62

May 05, 2019 00:15:39
Index Include Clause, Exporting CSV, JSON, Zedstore | Scaling Postgres 62

Index Include Clause, Exporting CSV, JSON, Zedstore | Scaling Postgres 62

In this episode of Scaling Postgres, we review articles covering the index include clause, exporting data to CSV, using JSON in Postgres and Zedstore....

Listen

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