Int to BigInt, Resistance is Futile, Optimizer Statistics, Advanced Query Optimization | Scaling Postgres 153
In this episode of Scaling Postgres, we discuss how to convert an integer primary key to a bigint, how container resistance is futile, how the optimizer uses statistics and how to set manual statistics. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/153-int-to-bigint-resistance-is-futile-optimizer-statistics-advanced-query-optimization/
Scaling Postgres · Creston Jamison
Audio is streamed directly from the publisher (episodes.castos.com) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
In this episode of Scaling Postgres, we discuss how to convert an integer primary key to a bigint, how container resistance is futile, how the optimizer uses statistics and how to set manual statistics.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/153-int-to-bigint-resistance-is-futile-optimizer-statistics-advanced-query-optimization/