5mins of Postgres E58: Handling integer sequence overflow without downtime
Today, I want to talk about the pg_stat_io view and the everyday DBA perspective on why it matters. We’ll go through tracking activity in Postgres with pg_stat_io and talk about getting insights into extends, evictions, reuses, and more.
Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
The Integer at the End of the Universe: Integer Overflow in Postgres - by Jesse Soyland
https://www.crunchydata.com/blog/the-...
Jesse Soyland on Twitter
/ jsoyland
The Night the PostgreSQL IDs Ran Out - by Jake Swanson
/ the-night-the-postgresql-ids-ran-out
Jake Swanson on Twitter
/ jakswa
Rails 5.1: Default Primary Keys - by Jon McCartie
https://www.mccartie.com/tech/2016/12...
PostgreSQL zero-downtime migration of a primary key from int to bigint (with Ruby on Rails specific notes) - by Radan Skoric
https://engineering.silverfin.com/pg-...