In this episode of Scaling Postgres, we discuss collation issues, how to load data quickly, recovery changes in Postgres 12 and moving to SCRAM authentication.

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

https://www.scalingpostgres.com/episodes/72-collation-issues-fast-loading-recovery-scram-authentication/

In this episode of Scaling Postgres, we discuss indexing documents, how GIN indexes work, using Postgres for Data Science and generated columns.

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

https://www.scalingpostgres.com/episodes/71-indexing-documents-gin-indexes-data-science-generated-columns/

In this episode of Scaling Postgres, we discuss the default security, max_connections and pooling, progress reporting and migrating to Postgres.

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

https://www.scalingpostgres.com/episodes/70-default-security-max-connections-progress-reporting-migration/

In this episode of Scaling Postgres, we discuss performance training, SQL/JSON path support, hypothetical indexes and linear interpolation of data.

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

https://www.scalingpostgres.com/episodes/69-performance-training-json-path-hypothetical-indexes-interpolation/

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/

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/

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/

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/

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/

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/