Latest Episodes
67
PGCon, Tips, PostGIS, Strings | Scaling Postgres 67
In this episode of Scaling Postgres, we discuss videos from PGCon, Postgres tips & tricks, PostGIS parallel performance and using strings. To get the...
66
Query Optimization, Normalization, Visualizing Vacuum, Sharding | Scaling Postgres 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...
65
Multi Column, Multi DB, Dos & Don'ts, RUM Indexes | Scaling Postgres 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...
64
Leveraging Indexes, Slugs, Addresses, Security Definer | Scaling Postgres 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...
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...
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....