Re: REPACK enhancements

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

Hi Antonin,

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.

The attached spec hits it every time. The diff sets the range start after
the replay. Both are against v03 plus your 9/18 diff.

Thanks,

Shihao

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2026-09-24 13:51:54 Re: Request to expedite commitfest account cool-off
Previous Message Jeevan Chalke 2026-09-24 13:17:37 Re: ON EMPTY clause for aggregate and window functions