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 1vRBfN-008r3j-13 for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Dec 2025 15:54:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vRBfM-003Ipt-0W for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Dec 2025 15:54:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vRBfL-003Ipl-2m for pgsql-hackers@lists.postgresql.org; Thu, 04 Dec 2025 15:54:48 +0000 Received: from mail-pj1-x1035.google.com ([2607:f8b0:4864:20::1035]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vRBfJ-0037rp-2h for pgsql-hackers@postgresql.org; Thu, 04 Dec 2025 15:54:47 +0000 Received: by mail-pj1-x1035.google.com with SMTP id 98e67ed59e1d1-343ea89896eso970812a91.2 for ; Thu, 04 Dec 2025 07:54:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1764863686; x=1765468486; darn=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=AAyqqw7nK5T4nCfUmVydH7xqrPTSjdWmpVFlwDiuURY=; b=WfeAklhNSx2i9Da9mQbZutxerwrEWIcLVf4Pai9rqacVegkcYS+oFkQX1NiCyZqn1z B4b+yOj/F+ziMuaCVc1MA9vOPxqBqAMQAy9Nqtle7N5iTn8Mt+oh1JIQwt3IbHbn21RR sCYPYDVtNPag60Rw8r3h98vcrYz77nFFmAZySBj5xTut2oHsUZHjaYEMnMCakXR9klYT IiWSyNcwAiodOIo4W2KhQk8aoWCdrcbrBtZmTd41eI9jjSc+I/blABUVK7p/ou5bsjAy c5kTP8ZnukzEnB92b545Qh9iJ4SttgmUeIhdxgUwAlUD98QSzGCXShJt2RuBtZ9uHXMD aYQA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764863686; x=1765468486; 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=AAyqqw7nK5T4nCfUmVydH7xqrPTSjdWmpVFlwDiuURY=; b=nLCZemLs1CRv6Stj7YXZeK7viucCx2t+8SGkS6qYmyOUS8Oy6DWd8v/GTzerr747vN ZSIxaXcz1/NgGVtGYlE6GcrAs5bG7Q4WNExeEtjC2U5+UA3p53DEYB0tabIpNbmjUg/J BffhGr1D7sRE+GJkvgkAgmIMzDLOWeoduiZ+7Dl8vmcg4ZtXRUZ/PjLRXHZ7VDrefRtm fV5G0fN0f1NkYzHBjBanXjouki/pMsVDOyfyM5e0WCKaazAd2k8IUSlgfVDHh/bXcB+e Wb76z8E194XQpV2FmUhGvoK2w2fptWyw/GVYImjCJKeITgMxQ6M7n7Vw5garoAcpzynU z/Ig== X-Gm-Message-State: AOJu0Yzt+kTWjnh6G+0bWpWDNOCaLVhLC+1eacGAzpThoxjSlvQ+bu3M 6dCPqskP58qhM8KsAqSztJ8eF0kvQDnBLXSu2AiQm7TAiMXDojPXf4AI84ir5WD2AbO0v0Tlxvl 2sFNYrXhWXuuxWprYbMUccmJH9VgBYJQ= X-Gm-Gg: ASbGncvbGuTC6605H0VXYANlQDerHg2z+OAICwTuSDHzajXRf4rLKqmvv0dcVKDdMAA RxtI/5VBkgNGyf1F4YLJh6nJJI72DxvqHwPlr2HCMFN6thfNNOLyoHpJIbbL8nf28pc9ZJjbYbi rl4Rxzf5JV5uiR3/hsDwc0tYEioOtphIaDHIcfdWF5lOIOF3R/4TDdfc4FEIdj43rJLuGaiaAjd Lx5zPwGNasZKfKckPPpXIEsbs3xwTpu714wzr/fjUOnGEpPte6Pou09Cg+mMRu31plcbAee X-Google-Smtp-Source: AGHT+IEeVl0dzlHZIxAxunVs8Y1VirEBsWMcsXo3bNpf+Mvsb/4phksl67JzVJZJEXkKpoo4nr5yCtLUqB0v4pctRaQ= X-Received: by 2002:a17:90b:1fc8:b0:340:ff7d:c2e with SMTP id 98e67ed59e1d1-349126b9982mr8179479a91.29.1764863685603; Thu, 04 Dec 2025 07:54:45 -0800 (PST) MIME-Version: 1.0 References: <68f3771f-91f5-4cb7-b1de-74d9abbf0b96@vondra.me> In-Reply-To: From: Amit Langote Date: Fri, 5 Dec 2025 00:54:29 +0900 X-Gm-Features: AWmQ_bnIGwRwZ3fO5VbVhSXp5CgFzXgQFNvCx0IgJyHlS-gYwXRNlZAUC4tcn4Q Message-ID: Subject: Re: Batching in executor To: Tomas Vondra Cc: PostgreSQL-development 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 On Wed, Oct 29, 2025 at 3:37=E2=80=AFPM Amit Langote wrote: > On Tue, Oct 28, 2025 at 10:40=E2=80=AFPM Amit Langote wrote: > > That would be nice to see if you have the time, but maybe after I post > > a new version. > > I=E2=80=99ve created a CF entry marked WoA for this in the next CF under = the > title =E2=80=9CBatching in executor, part 1: add batch variant of table A= M > scan API.=E2=80=9D The idea is to track this piece separately so that lat= er > parts can have their own entries and we don=E2=80=99t end up with a singl= e > long-lived entry that never gets marked done. :-) I intend to continue working on this, so have just moved it into the next fest. I will post a new patch version next week that addresses Daniil's comments and implements a few other things I mentioned I will in my reply to Tomas on Oct 28; sorry for the delay. --=20 Thanks, Amit Langote