Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: shihao zhong <zhong950419(at)gmail(dot)com>
Cc: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Subject: Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound
Date: 2026-10-16 08:45:33
Message-ID: atHjj64Jk4o1SGCO@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2026-Oct-15, shihao zhong wrote:

> Someone told me a story today. If you build a payroll app and it
> breaks one time in x, would you ship it? That one time is someone
> who does not get paid. A rare bug is still a real bug for whoever
> hits it.

Some definitely would.
https://en.wikipedia.org/wiki/British_Post_Office_scandal

The court cases, criminal convictions, imprisonments, loss of
livelihoods and homes, debts, and bankruptcies led to stress, illness
and family breakdowns, and were linked to at least thirteen suicides.
In 2024, Prime Minister Rishi Sunak described the scandal as one of
the greatest miscarriages of justice in British history.

--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"Sallah, I said NO camels! That's FIVE camels; can't you count?"
(Indiana Jones)

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Daniel Gustafsson 2026-10-16 08:42:07 Re: Fix pg_restore gzip stream validation (bug #19754)