Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wZ5A2-000l1X-0I for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Jun 2026 11:07:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wZ5A0-00BWNV-2Y for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Jun 2026 11:07:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wZ5A0-00BWNM-1Y for pgsql-hackers@lists.postgresql.org; Mon, 15 Jun 2026 11:07:20 +0000 Received: from charmander.telsasoft.com ([50.244.222.1] helo=pryzbyj2023.telsasoft) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wZ59y-00000000VAP-0XPk for pgsql-hackers@lists.postgresql.org; Mon, 15 Jun 2026 11:07:20 +0000 Received: by pryzbyj2023.telsasoft (Postfix, from userid 1000) id A89C0351D; Mon, 15 Jun 2026 06:07:15 -0500 (CDT) Date: Mon, 15 Jun 2026 06:07:15 -0500 From: Justin Pryzby To: Alexander Korotkov Cc: Dmitry Koval , Alexander Lakhin , pgsql-hackers@lists.postgresql.org, Tomas Vondra , Alvaro Herrera Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands Message-ID: References: <0f655bcd-6487-4179-f9cf-c248efbad510@gmail.com> <41117807-3bea-45bc-a9c0-743c29abff2d@postgrespro.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I hit an error when I tried this patch. CREATE TABLE a (a text) PARTITION BY RANGE(a); CREATE TABLE a1 PARTITION OF a DEFAULT; INSERT INTO a SELECT repeat('1', 9999999); CREATE TABLE a2 PARTITION OF a FOR VALUES FROM (2)TO(3); ALTER TABLE a MERGE PARTITIONS (a1, a2) INTO a1; ERROR: row is too big: size 39264, maximum size 8160 -- Justin