Re: REPACK enhancements

From: Antonin Houska <ah(at)cybertec(dot)at>
To: shihao zhong <zhong950419(at)gmail(dot)com>
Cc: Manu <manuelreyesbravo(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: REPACK enhancements
Date: 2026-09-24 14:02:34
Message-ID: 103630.1790258554@localhost
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

shihao zhong <zhong950419(at)gmail(dot)com> wrote:

> One more for 0008, for your next version.
>
> finalize_block_range() moves *range_start_dst_p before the replay. If the replay adds pages to the new heap, the next update_identity_index
> () indexes those rows again. REPACK then fails with a duplicate key error.

Right, I've noticed that earlier this week when addressing your other
findings. The fix will be included in the next version. Thanks.

--
Antonin Houska
Web: https://www.cybertec-postgresql.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2026-09-24 14:13:29 Re: potentially missed pgindent in REL_19_STABLE
Previous Message Joe Conway 2026-09-24 13:51:54 Re: Request to expedite commitfest account cool-off