Top all-time · #14035
Zemanta
Company blog · zemanta.github.ioprogrammingdataweb
Zemanta is the company blog at zemanta.github.io, writing about programming, data and web. Since 2016, 5 different Hacker News readers have linked it 8 times. The last post was in 2021, but the archive is still widely read.
Too few sampled comments (1) to say how often HN recommends it.?
Why HN links it
HN readers link this post as a recipe for migrating Postgres primary keys from int to bigint with zero downtime. One commenter says they are following it, with tweaks, for a large migration.
Summarised by Claude from a sample of 1 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
What Hacker News says?
Migrating primary keys from int to bigint is feasible. Requires some preparation and custom code, but zero downtime. I'm managing a big migration following mostly this recipe, with a few tweaks: http://zemanta.github.io/2021/08/25/column-migration-from-in... FKs, indexes and constraints in general make the process more difficult, but possible. The data migration took some hours in my case, but no need to be fast. AF…
Comment linking /2021/08/25/column-migration-from-int-to-bigint-in-postgresql/
on “My notes on Gitlab's Postgres schema design (2022)”Submitted Show HN: SecretCrypt – Keeping secrets in plain sight as a story · 75 points
HN discussionSubmitted Why we migrated away from Librato to InfluxDB? as a story · 46 points
HN discussionSubmitted First steps with Amazon Redshift as a story · 9 points
HN discussionSubmitted State management in Angular with observable store services as a story · 8 points
HN discussionSubmitted How I Learned Go as a story · 8 points
HN discussionSubmitted Detecting Suspicious Websites with Covisitation Graphs as a story · 6 points
HN discussionSubmitted Railway to Craftsmanship as a story · 5 points
HN discussion