Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

June 16, 2019 Prepared Plans, Materialization, Recursive CTEs, Safe Migrations | Scaling Postgres 68
In this episode of Scaling Postgres, we discuss prepared plans, materialization, recursive CTEs and how to run safe database migrations.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/68-prepared-plans-materialization-recursive-cte-safe-migrations/
17 min
June 09, 2019 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 show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/67-pgcon-tips-postgis-strings/
10 min
June 03, 2019 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 notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/66-query-optimization-normalization-visualizing-vacuum-sharding/
18 min
May 26, 2019 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 get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/65-multi-column-multi-db-dos-and-donts-rum-indexes/
15 min
May 20, 2019 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 as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/64-leveraging-indexes-slugs-addresses-security-definer/
14 min
May 12, 2019 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 get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/63-slow-queries-pg_auto_failover-roles-hyperscale/
13 min
May 05, 2019 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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/62-index-include-clause-exporting-csv-json-zedstore/
16 min
April 29, 2019 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 well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/61-constraint-triggers-simple-shards-data-streams-oids/
11 min
April 21, 2019 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 show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/60-pluggable-storage-developer-gotchas-cursors-pg12/
15 min
April 14, 2019 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 show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/59-popularity-load-testing-checksums-pg_hba/https://www.scalingpostgres.com/episodes/59-popularity-load-testing-checksums-pg_hba/
13 min

About Scaling Postgres

From the publisher's feed

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…