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 1t5cl4-007K7k-Hp for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Oct 2024 03:19:02 +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 1t5cl1-00Bu6d-Oa for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Oct 2024 03:19:00 +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 1t5cl1-00Bu3e-Cx for pgsql-hackers@lists.postgresql.org; Tue, 29 Oct 2024 03:18:59 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t5cky-003NEm-IV for pgsql-hackers@postgresql.org; Tue, 29 Oct 2024 03:18:58 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-5c937b5169cso7695017a12.1 for ; Mon, 28 Oct 2024 20:18:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1730171935; x=1730776735; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=m7H9fWJSiTmjAWcEaxLjduPRtilQ6xz8Lc7G2G7yVTI=; b=SuPRtGITkzd1nf9Wpq9/YYD7BtwuAyMxDSpSnssE71Zp8maKJKKiWM7JrmWQ3zXPXN Z0DBSu1FWXsMEvTjRvfWRK44nxaq6B02kHFlEH2T4g/ndSOYJufmhSWmP7Tl4xs/Iklz P4C/PJ9GUWlGGWcL3NBviEmfQEYaU8WcQQolgAiEWcQEWFkbQV5T3bFEXazFBE61F0XA HouNLlpgbLZr5MqTptyhyFxFfZ84YyQNuLoKs9EeUNTHqeO4Xwo8J328k0qMhLhY0pDs TvSCrKqyArpPkeVRZ/XyQN92w2f1vwdfVo4OOZ35beUpHiKCWxinweX6+Zd2XsLhuqXB BIug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730171935; x=1730776735; h=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=m7H9fWJSiTmjAWcEaxLjduPRtilQ6xz8Lc7G2G7yVTI=; b=ZN8HxXyYnJmD0zkmlY7hszsfaH6Pelwy/fluuyvO/7m3QrMAEUPRBxo61Y6rauyj7E 8PZHNYE1yjyPc528IUJ0JU1d6me6PFjzsxGvgDh377E6aClYhLHKCh5zaHRaQM4Uo9FN yo5dEsu/PTN9kLSF7s1UeGi7i9kjjAP6h+wk1AWLSIAOh1Rk/Ek7QJFLPj6yjqswKFGM uJoCNfwcfC/ufBLifHU2eGy33+4qYUAa8VNhwfLplSiffqfKXq5LUXqqDNGuKXHzSivx xoGwthwkzhts6GzjixwW5KvhNZGCvuh95erjwwTSHDIkNgmhohdfA7gk5BKP8wZjtcGc PSkA== X-Forwarded-Encrypted: i=1; AJvYcCWmyC3vUDexgTGiWNdWuAdEvlHFJjO1SJsePzhVAKXC86pKp4XXeo+C897cg/Rn/WJ2nLY+VcH4qy9XCbj/@postgresql.org X-Gm-Message-State: AOJu0YxN2ozA8MzEVDUwQcaxGg/ti7/4b8qcnz57gHxQLV4tH5XZr/D1 4HsBuSwHGuZFYmcTLNhbBBF0Vn2CnYbUAZS0fQMu3fJflDG0la6ETCWh2O/3uk7z6n4PEY90JWE /GAH68DWNAt0c+0AWY7g2eWQ54wI= X-Google-Smtp-Source: AGHT+IGqqKgKCYC+BjNRGMQBjOCYJ9o9p5kuo8u8ZjNBhoE4xz3Lh73kFna8MzhigxoB7fBQTvRLPeJwkAAcRsUtTik= X-Received: by 2002:a05:6402:26c5:b0:5cb:83c0:dd69 with SMTP id 4fb4d7f45d1cf-5cd2904da00mr507210a12.12.1730171934564; Mon, 28 Oct 2024 20:18:54 -0700 (PDT) MIME-Version: 1.0 References: <20230603223824.o7iyochli2dwwi7k@alap3.anarazel.de> <6be6f58815dc0844fbe058edf56b4e735a6efc1c.camel@j-davis.com> <2280bf7241119bb88cbe0fe5eb36490cbd04c0c0.camel@j-davis.com> <12f1a2d8dd3b6305c0354f1c701f44b7be5e54eb.camel@j-davis.com> <8633171cb034aafc260fdf37df04b6c779aa1e2f.camel@j-davis.com> <229c4f7219ed164088dadc935df21e1cf125e191.camel@j-davis.com> <23a29125a2d07f96d49f97c31fcdb09a7f0ff6c1.camel@j-davis.com> In-Reply-To: From: Jingtang Zhang Date: Tue, 29 Oct 2024 11:18:42 +0800 Message-ID: Subject: Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM To: Bharath Rupireddy Cc: pgsql-hackers@lists.postgresql.org, PostgreSQL-development Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi~ Sorry for multiple comments in separate mail. Just found that the initialization seems redundant since we have used palloc0? > + istate = (HeapInsertState *) palloc0(sizeof(HeapInsertState)); > + istate->bistate = NULL; > + istate->mistate = NULL; --- Regards, Jingtang