On Mon, Dec 2, 2024, at 4:07 AM, PG Bug reporting form wrote:
UPDATE rqg_table3 T2
SET c2 = T2.c2 || '该行序号不正确;'
WHERE NOT EXISTS (
SELECT NULL
FROM (
SELECT c1, c0, c2 AS RIGHT_NUM
FROM rqg_table3
ORDER BY c1
) T3
WHERE T3.RIGHT_NUM = T2.c2
AND T3.c0 = T2.c0
);
It works for v14+. That's because there were some partitioning improvements. In
particular, the commit 86dc90056 and follow up commits. The release notes
describe it as "Improve the performance of updates and deletes on partitioned
tables with many partitions".
I would say that it is time to move from v13 because it is now the oldest
supported version.
