Podcast Episodes

PGCon, Tips, PostGIS, Strings | Scaling Postgres 67

Episode 67

In this episode of Scaling Postgres, we discuss videos from PGCon, Postgres tips & tricks, PostGIS parallel performance and using strings.

To get the show notes as well as get notified of new episode…

Published on 6 years, 6 months ago

Query Optimization, Normalization, Visualizing Vacuum, Sharding | Scaling Postgres 66

Episode 66

In this episode of Scaling Postgres, we discuss different query optimizations, normalizing to save space, visualizing vacuum and shardings future.

To get the show notes as well as get notified of new…

Published on 6 years, 6 months ago

Multi Column, Multi DB, Dos & Don'ts, RUM Indexes | Scaling Postgres 65

Episode 65

In this episode of Scaling Postgres, we discuss multi-column indexes, using multiple databases, Postgres dos & don'ts as well as using RUM indexes.

To get the show notes as well as get notified of ne…

Published on 6 years, 6 months ago

Leveraging Indexes, Slugs, Addresses, Security Definer | Scaling Postgres 64

Episode 64

In this episode of Scaling Postgres, we discuss leveraging indexes, a slug function, addresses and security definer in functions.

To get the show notes as well as get notified of new episodes, visit:…

Published on 6 years, 7 months ago

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

Episode 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 get the show notes as well as get no…

Published on 6 years, 7 months ago

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

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

To get the show notes as well as get notified of…

Published on 6 years, 7 months ago

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

Episode 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 well as get notified of new episodes, visit: 

http…

Published on 6 years, 7 months ago

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

Episode 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 show notes as well as get notified of new e…

Published on 6 years, 8 months ago

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

Episode 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 show notes as well as get notifie…

Published on 6 years, 8 months ago

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

Episode 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 notes as well as get notified of new e…

Published on 6 years, 8 months ago