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 1w5w89-003mOe-2z for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 01:36:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5w88-006zen-1G for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 01:36:56 +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 1w5w87-006zZf-0s for pgsql-hackers@lists.postgresql.org; Fri, 27 Mar 2026 01:36:56 +0000 Received: from mail.clear-code.com ([2401:2500:102:3037:153:126:203:179]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w5w85-00000001EjV-0hYX for pgsql-hackers@postgresql.org; Fri, 27 Mar 2026 01:36:54 +0000 Received: from localhost (unknown [IPv6:2404:7a80:9f01:f500:5950:362a:f311:d0d2]) by mail.clear-code.com (Postfix) with ESMTPSA id 944B078139E; Fri, 27 Mar 2026 10:36:42 +0900 (JST) DKIM-Filter: OpenDKIM Filter v2.11.0 mail.clear-code.com 944B078139E DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=clear-code.com; s=default; t=1774575402; bh=9hG+xaQsKxCSclpWm+V/wan4Yf0k2YA/H6h/bRAmIcY=; h=Date:To:Cc:Subject:From:In-Reply-To:References:From; b=sJPaeg3WZIIBuMKLHIpiF3IeyK3WPEweIfLo59W/cceirS8sLxi+hNJlcvdGfEZyU 2iu/yCwzRjCSMu68/mB9TKx/uRq0TKQ1avuXCsFWJ3XesS1X+T7B1zAH2UBvFcLdtp VNRo1bsL0OaxEVlvlM8bx8wypT5i2E5UBGzQCDOE= Date: Fri, 27 Mar 2026 10:36:40 +0900 (JST) Message-Id: <20260327.103640.1195140797832123502.kou@clear-code.com> To: sawada.mshk@gmail.com Cc: tomas@vondra.me, andres@anarazel.de, michael@paquier.xyz, david.g.johnston@gmail.com, tgl@sss.pgh.pa.us, zhjwpku@gmail.com, pgsql-hackers@postgresql.org Subject: Re: Make COPY format extendable: Extract COPY TO format implementations From: Sutou Kouhei In-Reply-To: References: <20251202.113957.631944095477627464.kou@clear-code.com> X-Mailer: Mew version 6.8 on Emacs 30.2 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Rspamd-Server: mail.clear-code.com X-Rspamd-Queue-Id: 944B078139E X-Spamd-Result: default: False [2.90 / 999.00]; SUSPICIOUS_RECIPS(1.50)[]; MID_CONTAINS_FROM(1.00)[]; MV_CASE(0.50)[]; MIME_GOOD(-0.10)[text/plain]; ASN(0.00)[asn:2518, ipnet:2404:7a80::/29, country:JP]; ARC_NA(0.00)[]; FREEMAIL_TO(0.00)[gmail.com]; RCPT_COUNT_SEVEN(0.00)[8]; RCVD_COUNT_ZERO(0.00)[0]; FREEMAIL_ENVRCPT(0.00)[gmail.com]; ALIAS_RESOLVED(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; FROM_HAS_DN(0.00)[]; MIME_TRACE(0.00)[0:+]; FROM_EQ_ENVFROM(0.00)[]; TO_DN_NONE(0.00)[]; LOCAL_OUTBOUND(0.00)[]; FREEMAIL_CC(0.00)[vondra.me,anarazel.de,paquier.xyz,gmail.com,sss.pgh.pa.us,postgresql.org] X-Rspamd-Action: no action List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, In "Re: Make COPY format extendable: Extract COPY TO format implementations" on Thu, 18 Dec 2025 15:43:07 -0800, Masahiko Sawada wrote: > Looking at these results, it seems that 0001-from-binary cases and > 0006-to-binary cases are slower throughout the six results? Good point. I didn't notice them. But I feel that it's not related to the patch set. Because 0001 doesn't change COPY FROM related code. 0001 just changes COPY TO related code. And 0006 just adds tests. 0006 doesn't change implementations. BTW, how to proceed this proposal? It seems that we can't proceed this proposal without PostgreSQL committers' attentions but it seems that it's difficult. Thanks, -- kou