Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

From: Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>
To: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Date: 2025-02-03 15:37:47
Message-ID: ff30dc7e-ebca-42a2-9d49-a66c9a3c7ee5@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi, Alexander!
Thanks for your advices and recommendations!

>I don't think we need a separate 0003 patch with refactoring. It's
>probably good idea to keep this functionality as a separate patch, but
>let's make then it a 0001, which prepares functions used by 0002 and
>0003.

Done. 0003 was created separately to better understand what changes were
made after the verified changes 0001 and 0002.

>Please, check my thoughts on how this patch could be further
>developed. Given amount of work to be done, I doubt that'a a subject
>for pg18. But I think you could continue this work, and we could
>consider it for early pg19 cycle.

Good. I'll try to collect and summarize the opinions of colleagues on
these issues [1], and then put them up for discussion in this thread.

Links.
[1]
https://www.postgresql.org/message-id/CAPpHfdtSxrcxQERO82cyQ2heN3%2BA7VC63k8SmL%3DEEiph-8rfHg%40mail.gmail.com

--
With best regards,
Dmitry Koval

Postgres Professional: http://postgrespro.com

Attachment Content-Type Size
v36-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch text/plain 146.5 KB
v36-0002-Implement-ALTER-TABLE-.-SPLIT-PARTITION-.-comman.patch text/plain 211.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-02-03 16:00:48 Re: SQLFunctionCache and generic plans
Previous Message Nisha Moond 2025-02-03 14:33:57 Re: Introduce XID age and inactive timeout based replication slot invalidation