Request a Demo
Home   >   mailing lists

Re: REPACK enhancements - Mailing list pgsql-hackers

From shihao zhong
Subject Re: REPACK enhancements
Date
Msg-id CAGRkXqTNv6BOCx71UQxER21gcnpU_yyXrg6vVghwNyUvTCwDcw@mail.gmail.com
Whole thread
In response to Re: REPACK enhancements  (Antonin Houska <ah@cybertec.at>)
Responses Re: REPACK enhancements
List pgsql-hackers
Tree view

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

pgsql-hackers by date:

Previous
From: Jeevan Chalke
Date:
Subject: Re: ON EMPTY clause for aggregate and window functions
Next
From: Joe Conway
Date:
Subject: Re: Request to expedite commitfest account cool-off