From: | amul sul <sulamul(at)gmail(dot)com> |
---|---|
To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
Cc: | Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key |
Date: | 2018-03-19 06:18:36 |
Message-ID: | CAAJ_b969qZTJwYbj5WM0vKEs+RTM4s1D8VS8uWUhX+YbFZGV8Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sat, Mar 17, 2018 at 4:32 PM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> On Mon, Mar 12, 2018 at 6:33 PM, amul sul <sulamul(at)gmail(dot)com> wrote:
>> On Mon, Mar 12, 2018 at 11:45 AM, amul sul <sulamul(at)gmail(dot)com> wrote:
>>> On Sat, Mar 10, 2018 at 5:25 PM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>>>> complete CTID.
>>>
>>> Sure, will do that.
>>
>> I did the aforementioned changes in the attached patch, thanks.
>>
>
> --- a/src/include/storage/itemptr.h
> +++ b/src/include/storage/itemptr.h
> @@ -23,7 +23,9 @@
> * This is a pointer to an item within a disk page of a known file
> * (for example, a cross-link from an index to its parent table).
> * blkid tells us which block, posid tells us which entry in the linp
> - * (ItemIdData) array we want.
> + * (ItemIdData) array we want. blkid is marked InvalidBlockNumber when
> + * a tuple is moved to another partition relation due to an update of
> + * the partition key.
>
> I think instead of updating this description in itemptr.h, you should
> update it in htup_details.h where we already have a description of
> t_ctid. After this patch, the t_ctid column value in heap_page_items
> function will show it as InvalidBlockNumber and in the documentation,
> we have given the reference of htup_details.h. Other than that the
> latest version looks good to me.
>
Okay, fixed in the attached version.
> I have marked this patch as RFC as this is a small change, hope you
> can update the patch soon.
>
Thank you, updated patch attached.
Regards,
Amul
Attachment | Content-Type | Size |
---|---|---|
0001-Invalidate-ip_blkid-v7.patch | application/octet-stream | 19.0 KB |
0002-isolation-tests-v6.patch | application/octet-stream | 23.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2018-03-19 06:27:16 | Re: Online enabling of checksums |
Previous Message | Amit Langote | 2018-03-19 06:04:18 | Re: ON CONFLICT DO UPDATE for partitioned tables |