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.94.2) (envelope-from ) id 1vDvqA-001Z0t-Sd for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Oct 2025 02:23:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vDvq8-00GC2N-AU for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Oct 2025 02:23:07 +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.94.2) (envelope-from ) id 1vDvq7-00GC2E-VQ for pgsql-hackers@lists.postgresql.org; Wed, 29 Oct 2025 02:23:07 +0000 Received: from mail-pf1-x42f.google.com ([2607:f8b0:4864:20::42f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vDvq5-004J5W-0E for pgsql-hackers@postgresql.org; Wed, 29 Oct 2025 02:23:05 +0000 Received: by mail-pf1-x42f.google.com with SMTP id d2e1a72fcca58-7a435a3fc57so2894357b3a.1 for ; Tue, 28 Oct 2025 19:23:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761704583; x=1762309383; 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=wYJYKTMTyiawR+aQXIohbfx6x4ZGTGaHD+1GK1Ge8ls=; b=kdBcUuS/ZE38Ep+6ivydIIQuaEXW5wLqO4Sd+4n1zVxt3UznxSVg7FvrHRB8OLSkKO D9UGjmRRcGomZhKCXoBzZA8tIqjVvs6kqQtrg38rUCYLp8EgYuv3ySgD9e7vduGwo80S eW+IRxJIpRgD0jWu6Lb0mKx0PCR2Vl141zAWufhuK1uu9Rc9XnFsxqBXM0p8Hp49xqLw WOwNAW+fKsjLh/Vkf3FPXKkYPAA12YWlU+LImE5G1fEHlbKl/Zpx5jCBGXDHyAPA0cbz wMmCtFTTu/lH126bXQzBKQoDPkfXzPPhbbJa+J6V70x+my8X98/bVMQw6rdwEvhs+sSR PLUA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761704583; x=1762309383; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=wYJYKTMTyiawR+aQXIohbfx6x4ZGTGaHD+1GK1Ge8ls=; b=UjJG9plcv2//u2IpF92AEUVjowMbVv3b/viBIv+GF7lS3bFlMPWiWj48CCOLNWwnzF I+1tOKJigWR6blhLbQUXBuPzOn9XZ86OT/eSTKaZAXKAsgxSDHIUEvevI0G5FVNinYRr gGdm+tcWr7yjEdwamYKTfcRi1qVhVR3dodfD1OwkQNsJoWfmaqZzTvrIGAVjvFxvQV/S bHEKoYcO9tkqLCjqjyRYdH8kC7XVqpWOTWXxwbn8RULp+tSz0f1zHGd7Sipi/jCqV5hz nSZn+BKkTM9wRnits4UvFV9FRop7D7yl3DbFxVteWqFWiRCfCMURi/hVsUlmpTj04JQN MaHg== X-Forwarded-Encrypted: i=1; AJvYcCX+uRIdLPpXzjDJIkmyd7NZ7AVvW7zXbhPesEJUJ3CsPgFn2i57VwTuG9vG/Sm1tdCAK/fzB3nannPDJowV@postgresql.org X-Gm-Message-State: AOJu0YzUrGreLE6Xw8m47AJFUHcCga0JWHQkLYKLyU1rbb25sRWiGtoZ zdUej8gpBXf32OxapfQQBckg8wusUl8OBeyIM7ofueaSSMSPK3piGiLkMt+bnKUlBaEkyvqF9L7 iErgION+M6QWZerOfEMys8jttDolN9Qg= X-Gm-Gg: ASbGncvEr7YXYJ07DeYGhGnR3cEceMW8ydaHBoR0ecx6g1CqYeZ/t2BaHGgjt2Ie8jG gXSkRytmvZQ/aVfyPdbMJl7fh3l48M6txNhvasO+Vpz9a1+p+PvG+V4xpCiLc7bcfScWxsYIIo0 wQZmsqEmpksTpAPwW24dShO4kxMQSBpXMtPwfIXu2YY+Y86gpoyY/Gfbc/er9fvw5SCb14TME6L pdK2i12iBocF/zdMlRDU6vk4QZBlG3l5kyr8y3/XAycI5DTOkDHLA3upfIEtA== X-Google-Smtp-Source: AGHT+IEI0KbGzcZSGKwvZN5g61ohlQUIy/WawJXlV+STkiWWczdKC/oiKZ8nf/AZIWgjd/RpVxjUwGXmzkIF6jbAETs= X-Received: by 2002:a05:6a20:2583:b0:334:8dcb:567b with SMTP id adf61e73a8af0-34653d33193mr1582885637.52.1761704583386; Tue, 28 Oct 2025 19:23:03 -0700 (PDT) MIME-Version: 1.0 References: <68f3771f-91f5-4cb7-b1de-74d9abbf0b96@vondra.me> In-Reply-To: From: Amit Langote Date: Wed, 29 Oct 2025 11:22:47 +0900 X-Gm-Features: AWmQ_bkf9wlrVwNWkpSc2HfLuOjAuOgTiVLpInTJCiuNaNO5p9fOdWL4yhQsH0M Message-ID: Subject: Re: Batching in executor To: Daniil Davydov <3danissimo@gmail.com> Cc: Tomas Vondra , 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 Hi Daniil, On Tue, Oct 28, 2025 at 11:32=E2=80=AFPM Daniil Davydov <3danissimo@gmail.c= om> wrote: > > Hi, > > As far as I understand, this work partially overlaps with what we did in = the > thread [1] (in short - we introduce support for batching within the Modif= yTable > node). Am I correct? There might be some relation, but not much overlap. The thread you mention seems to focus on batching in the write path (for INSERT, etc.), while this work targets batching in the read path via Table AM scan callbacks. I think they can be developed independently, though I'm happy to take a look. --=20 Thanks, Amit Langote