Re: MERGE/SPLIT PARTITIONS issues/questions

From: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
To: Melanie Plageman <melanieplageman(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Subject: Re: MERGE/SPLIT PARTITIONS issues/questions
Date: 2026-08-12 20:56:56
Message-ID: CAN4CZFOYFN9ZhJY9i7pbnj1aAr=MA-60G1KSw3-Aj+hMgxeBeg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

> I'm worried that despite the documentation, users might find this
> surprising -- and by the time they realize it happened, it might be
> too late.

This was one of my reasons for mentioning it. Printing out at least a
WARNING for them would make them more visible (but it still has the
problem that the mistake already happened - what if the user didn't
dump the settings before splitting?), or it could be even an ERROR by
default that would require an extra clause to override. But either of
those requires at least the code to detect these issues.

My other worry is that it could be also confusing if we have silently
different behavior in 19 and 20. Let's say all of these will be
implemented in PG20 and later. And then a dba has to deal with some
merge/split on a PG19 server, and doesn't realize that some settings
are now missing, because it works differently in 20/21/... So maybe
even with support in later versions, it would require something like
INCLUDING ALL?

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Melanie Plageman 2026-08-12 21:30:18 Re: DELETE FOR PORTION OF bypasses view WITH CHECK OPTION for leftover rows
Previous Message Melanie Plageman 2026-08-12 20:48:36 Re: MERGE/SPLIT PARTITIONS issues/questions

Browse pgsql-hackers by date

  From Date Subject
Next Message Melanie Plageman 2026-08-12 21:23:46 Re: Re-read conindid under the referenced table's lock in the RI fast path
Previous Message Melanie Plageman 2026-08-12 20:48:36 Re: MERGE/SPLIT PARTITIONS issues/questions