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 1wa7Dm-001Xes-1q for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jun 2026 07:31:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wa7Dl-00AJnj-1n for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jun 2026 07:31:29 +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 1wa7Dl-00AJnb-0d for pgsql-hackers@lists.postgresql.org; Thu, 18 Jun 2026 07:31:29 +0000 Received: from mail-qt1-x82d.google.com ([2607:f8b0:4864:20::82d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wa7Di-000000013TM-3lOI for pgsql-hackers@lists.postgresql.org; Thu, 18 Jun 2026 07:31:28 +0000 Received: by mail-qt1-x82d.google.com with SMTP id d75a77b69052e-5176ca6bab1so7315811cf.0 for ; Thu, 18 Jun 2026 00:31:26 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781767885; cv=none; d=google.com; s=arc-20240605; b=fq3Z9vqEoHKck+fpVZUZhlWKzzjwXYJdx/eQjj9TPihfhMeimAvhAuwrtIuAmfhgmd dmjcuSp9ihZPTy6JQAtEEOMmdqkjZsbsrEnr/wOh312PJ58TuxB0KLGe9hCGx5yGuI/P 087bDw1oTkOopc4cRSi1qVsNR4YTOPy1BPB4/OXXRyzLR4yyxsFz/gW2/r2nucHv29I1 izT0FW1CkJI1zysCnXlxn3uAiQ3ksC9ypm6/uEGoIqjozuphBZ9PyVnaoziBQ1U1EefK wxWaqf8Tk1PLALfE/8pv3KHrYUT9yy0oZJbe7j5f6EvPGt3i7DC5VRCuDkke6/oep7xD IdpA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=jn7kBvZyb5P1cbe3rmokaMd2d2OUgPWAWj7Ztu74Iwc=; fh=aNExOzzJVm8kpnkqkNC1AlHlZpn0zhIsfDo/fkjqzM0=; b=IY2G5Ss8tqC+JF9tVR8J0APYTwhFVvXiUbAzrtKOZCTx95GofYcNE1FYOSQWijR4XQ M2ZkpD+xf16aMjmdrRHZDOSWnkK8Kgm8dPVqbaYbh2xaFvJpm0b9uKUkBBtT2l6XXbSb lN1SBn1seKjY2wIiMctnQllJ19oHrdauqbKC2DHli+hmAPUpn2XiRP8UYELXnCrDX+fL xuQqHnvIGo10Qdor7IFwFxdh5cdIkoqXhBKyVKcMWw+aA8W+GY3gi5bpKl07CiLA0s/+ 2eI5ckGvcYM6789hMCICIezWZbfwSPVBKib04fbD9nh3xDIkAl3n2aEmq2H2UwMRls1U +TPQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1781767885; x=1782372685; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=jn7kBvZyb5P1cbe3rmokaMd2d2OUgPWAWj7Ztu74Iwc=; b=rApMBclrmf80NZp8daaA8lFby7NZt//4Wiyr6OaPsYmXnLMQDXbdfrNsPOy5aegpfv zNLwwQkV5L9rJLv3NL4GYbXgjwfuUgQ1q3RBSir8JwHL5rHdwAno6Oa7riba2T71EB/3 ak/vZ6SFwR5rvrSJnpYwGcGblEimziqUUZ7YAlhEI8RXhAq01TrsYGmoCnggGiZkHsFP FJUnMtrhiJO2OliBiXNDzkpOrvaw1ihKFH1jhxEyUfxkSgEDPKDC/4dBK0QSSrDEvSdf hLrDeDoujCfjWtEHiONf6hk8hn3eE0U4xkc74vjmxI0HGzgeHknLU9FXbyaraNmhxWU0 BaxQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781767885; x=1782372685; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=jn7kBvZyb5P1cbe3rmokaMd2d2OUgPWAWj7Ztu74Iwc=; b=dFNu2ApjpKn7m+J3R+LJkzMgZDHlQgrGWpBSVWRLyiioXFs1QaEYEV2DTigQdzklxd 69I1vz/2ymhzR44AUmBWEssshZ0ZUmZEiyNqixzZ0fbkWGOmu7BCvyLZ+IQT78qE6+Y7 OLnwFzifcSjGP85Bmb8yOWz/GVuATdpOrs/TuJ99p+iCd2jvNJiXcd4Ekl+NVYBdcuyp v0U6/38HxlTWlMWvcu3VLjXv8pg3+c7lWUjCSOM2rgVgqmdmjPrum6k9oM4UkPEHTiKX UN1PfjrfFQBiop6ByYAd2eIAm1Xqm+hHGf1GUYReWveHT4eHv8VKF9w1/sX2KhM0+uBX 950g== X-Forwarded-Encrypted: i=1; AFNElJ8iLIRmeV/qwOzUJLIqk7Ep0byNYTyAzJa7u2mfdF2jQcKdBz923r5BHB1D2DV0tBPL5ulZ2I+8974OPrWO@lists.postgresql.org X-Gm-Message-State: AOJu0YzqRL8thjeqAJdG/sxZz+7xGGnyeiuAyHrFhcm1oxHxy0xK+/eV 0/JTh1DKIOl+IFdA/EvRtO/k3PuLIkyoxtPWMdHBIrUH7fLXrwbXrScVu6XjIzXewY/qiY03t+F XoonBwh1XUZpgBqmaEDyfqmFaKXlXXfM= X-Gm-Gg: Acq92OFt+QdLXRWkGrkAq1SRFeYqm4Q93dtfUj9TchOQXJ0ummyb46qld/5zul1bA8z 8HQNstgJXik1scN9+3w4RE4YvYZhZd33hoNBovH/6YqTk5uqb6IW186yksmlcgB2eR8MXWySI5u b8Tr1pPd/tTVqcTgdZfJXC/vSFuHHMkqEZQd+1OrLc41TQz/I1zCetthP2FmOzEE6wk78mmk7LX TUNu3rMuEXsoejMmogM0oaU1sB6lYuXZI2rmG8IU2VCtRH1ewBY9d8fl/NrI46axU/d7008A1XI Dnzr1xEzHx7It+nAnsDGw3nwYjULrIBuLdK68QimVcF8K5aU+iPv1pKARNZmcrdJCsGfU0E= X-Received: by 2002:a05:622a:1a9d:b0:517:7871:693f with SMTP id d75a77b69052e-519c4b91efemr36291821cf.8.1781767885097; Thu, 18 Jun 2026 00:31:25 -0700 (PDT) MIME-Version: 1.0 References: <0f655bcd-6487-4179-f9cf-c248efbad510@gmail.com> <41117807-3bea-45bc-a9c0-743c29abff2d@postgrespro.ru> In-Reply-To: From: Alexander Korotkov Date: Thu, 18 Jun 2026 10:31:11 +0300 X-Gm-Features: AVVi8CdGEdusB2xSHai97GXIp_BDk8Q3KfEL1lqP5g2p-9Dq05BBRWDFfufs-6o Message-ID: Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands To: Pavel Borisov Cc: Justin Pryzby , Dmitry Koval , Alexander Lakhin , pgsql-hackers@lists.postgresql.org, Tomas Vondra , Alvaro Herrera Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Pavel! On Tue, Jun 16, 2026 at 4:01=E2=80=AFPM Pavel Borisov wrote: > > Extending the syntax to accept WITH (...) on new partitions would be a > > separate, larger feature. Out of scope for this bug fix. > > I agree, this is out of scope of a fix. > Updated test in v2 and overall patch looks good to me. > > A couple of wording proposals: > never gave it -> never gives it > Merged partitions need their own TOAST table -> A merged partition > needs its own TOAST table. > re-stored -> stored > a short string suffices -> a string over that threshold suffices Pushed with your suggestions accepted. ------ Regards, Alexander Korotkov Supabase