Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ksd1j-0007Sx-NZ for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Dec 2020 02:40:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ksd1i-0000Hk-Jm for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Dec 2020 02:40:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ksd1i-0000Hd-7c for pgsql-hackers@lists.postgresql.org; Fri, 25 Dec 2020 02:40:22 +0000 Received: from mail-io1-xd2a.google.com ([2607:f8b0:4864:20::d2a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ksd1e-0005Im-Ry for pgsql-hackers@postgresql.org; Fri, 25 Dec 2020 02:40:21 +0000 Received: by mail-io1-xd2a.google.com with SMTP id w18so3264148iot.0 for ; Thu, 24 Dec 2020 18:40:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=/KPEbCGq8t2Tp2kFLIol4Yb4iADSS3V9knWK57tpUmM=; b=Px9o6x1xVy/mfuNEc84f0SkvWc9uj+9yKeyaKeGnddaBk9clUvtBfOccgpsNZARyX6 aeq/LWqAK5Okg639gNtEHQ6Ld1UFbHaU2X+gKw6inIXSDBWXZuCQ/VARFX0PYwV2uyjP DTn5D2l9oEumr1yU4XSfbohscW9GZ/etrK/mSl8eSqG5wVWoaWl1jkwkvsFHJW3tEgfX h7J5F0k8d+vTABDYrzowxoc68lad2z3Jn1nZJViCmffwhzf40CdcmyYPmzRfG7gl935n zBKY4WeitcWMR5oXVEzsM7CAIjAljJqt0z0GbOmvZHAF+PLGdyM56VHajIHvb2KDnow1 oy4A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=/KPEbCGq8t2Tp2kFLIol4Yb4iADSS3V9knWK57tpUmM=; b=cdtRMUaDE9cswcfqNxRYuy7AVl722sQMT/o66fr2Dy4+htE9AyeEXlv5dVa3SWSm2P 3yLXWly2noFPTd6w6PJzWd7TSImElkwOELbF7uTgRhkqjTzSLscfk9DO0LJflzdA8Dif GHJBLLd7dqLJgq3WFmsHLl4MQ/5c5H8BbjOp/drvqiRBJT5I9PcU7yKJfP+SI3orJWoi i3lWNBAhmWNC3BvA4iAvjVajF3+akVwGRK6mVwtBDUp9zUNQdJj3Q67zaULv89AfjfEh h/1/vqWAcbbl+Hw7365sKglKGdh4+LU89Dk06ZVI9OWtXQ/3n/5KfGLgySCXnpBDVd1A w+BA== X-Gm-Message-State: AOAM532jW3iQQH8AB8vEhi2Fv6+gN4XK1iDa34pgqKpP+3x1GYyu/ERI AX8UhvFak/vdXvqCpMugjk4+Yw== X-Google-Smtp-Source: ABdhPJxOWgbUtnrTND4KKQLP6yO7yOekrWFwxoPI7wIsAKGIVRCpnnIsldcyh2LxLrHwXJ0rq9VQFA== X-Received: by 2002:a6b:6d1a:: with SMTP id a26mr27327696iod.158.1608864016833; Thu, 24 Dec 2020 18:40:16 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id t21sm21674298ild.86.2020.12.24.18.40.15 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 24 Dec 2020 18:40:16 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 00A62800F41; Thu, 24 Dec 2020 20:40:14 -0600 (CST) Date: Thu, 24 Dec 2020 20:40:14 -0600 From: Justin Pryzby To: Bharath Rupireddy Cc: pgsql-hackers@postgresql.org, Andres Freund , Luc Vlaming , Paul Guo , Jeff Davis Subject: Re: New Table Access Methods for Multi and Single Inserts Message-ID: <20201225023958.GW30237@telsasoft.com> References: <20201217050522.GU30237@telsasoft.com> <20201217204442.GX30237@telsasoft.com> <20201218175439.GA30237@telsasoft.com> <20201221074725.GF30237@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Dec 24, 2020 at 05:48:42AM +0530, Bharath Rupireddy wrote: > I'm not posting the updated 0002 to 0004 patches, I plan to do so > after a couple of reviews happen on the design of the APIs in 0001. > > Thoughts? Are you familiar with this work ? https://commitfest.postgresql.org/31/2717/ Reloptions for table access methods It seems like that can be relevant for your patch, and I think some of what your patch needs might be provided by AM opts. It's difficult to generalize AMs when we have only one, but your use-case might be a concrete example which would help to answer some questions on the other thread. @Jeff: https://commitfest.postgresql.org/31/2871/ -- Justin