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 1rAhuQ-007rBh-BY for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Dec 2023 02:45:12 +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 1rAhuO-0076xA-88 for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Dec 2023 02:45:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rAhuN-0076x2-5N for pgsql-hackers@lists.postgresql.org; Wed, 06 Dec 2023 02:45:07 +0000 Received: from mail.clear-code.com ([2401:2500:102:3039:153:126:206:245]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rAhuE-00AJyN-PH for pgsql-hackers@postgresql.org; Wed, 06 Dec 2023 02:45:06 +0000 Received: from localhost (unknown [IPv6:2404:7a80:89c1:1200:1653:202c:ea56:2daf]) by mail.clear-code.com (Postfix) with ESMTPSA id DE2A163357C; Wed, 6 Dec 2023 11:44:49 +0900 (JST) DKIM-Filter: OpenDKIM Filter v2.11.0 mail.clear-code.com DE2A163357C DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=clear-code.com; s=default; t=1701830690; bh=8WAQc+A0F5QZqDfPvtQ6dJWamGb7xs8Kb+ZcIfYkdXc=; h=Date:To:Cc:Subject:From:In-Reply-To:References:From; b=foTpmVgkrL2dXV7z17aEr5qaItaw7Lu2MJ8wMzAAk5SttwXOcyF3jRw8rpp/PEwQ2 jr0QpJ8+MFcypFqJ+zpyH53hal891t8RTiNUYq9JdG8YkifGtCC+nQpYnfqbYgtYEf h4EGyfkuWGmYWtpKqNNXFK418dwepF1HFWo+0I1w= Date: Wed, 06 Dec 2023 11:44:47 +0900 (JST) Message-Id: <20231206.114447.44522233883022594.kou@clear-code.com> To: nathandbossart@gmail.com Cc: pgsql-hackers@postgresql.org Subject: Re: Make COPY format extendable: Extract COPY TO format implementations From: Sutou Kouhei In-Reply-To: <20231205182458.GC2757816@nathanxps13> References: <20231204.153548.2126325458835528809.kou@clear-code.com> <20231205182458.GC2757816@nathanxps13> X-Mailer: Mew version 6.8 on Emacs 29.1 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Rspamd-Queue-Id: DE2A163357C X-Rspamd-Server: mail.clear-code.com X-Spamd-Result: default: False [1.40 / 999.00]; MID_CONTAINS_FROM(1.00)[]; MV_CASE(0.50)[]; MIME_GOOD(-0.10)[text/plain]; FREEMAIL_TO(0.00)[gmail.com]; ASN(0.00)[asn:2518, ipnet:2404:7a80::/29, country:JP]; RCVD_COUNT_ZERO(0.00)[0]; RCPT_COUNT_TWO(0.00)[2]; ARC_NA(0.00)[]; FREEMAIL_ENVRCPT(0.00)[gmail.com]; URIBL_BLOCKED(0.00)[postgresql.org:url,nathanxps13:email,localhost:helo]; FROM_HAS_DN(0.00)[]; MIME_TRACE(0.00)[0:+]; FROM_EQ_ENVFROM(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; TO_DN_NONE(0.00)[]; SURBL_MULTI_FAIL(0.00)[postgresql.org:server fail,nathanxps13:server fail,localhost:server fail] X-Rspamd-Action: no action List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Thanks for replying to this proposal! In <20231205182458.GC2757816@nathanxps13> "Re: Make COPY format extendable: Extract COPY TO format implementations" on Tue, 5 Dec 2023 12:24:58 -0600, Nathan Bossart wrote: > I think it makes sense to do this part independently, but we should be > careful to design this with the follow-up tasks in mind. OK. I'll keep updating the "TODOs" section in the original e-mail. It also includes design in the follow-up tasks. We can discuss the design separately from the patches submitting. (The current submitted patch just focuses on refactoring but we can discuss the final design.) > I assume the performance concerns stem from the use of > function pointers. Or was there something else? I think so too. The original e-mail that mentioned the performance concern [1] didn't say about the reason but the use of function pointers might be concerned. If the currently supported formats ("text", "csv" and "binary") are implemented as an extension, it may have more concerns but we will keep them as built-in formats for compatibility. So I think that no more concerns exist for these formats. [1]: https://www.postgresql.org/message-id/flat/3741749.1655952719%40sss.pgh.pa.us#2bb7af4a3d2c7669f9a49808d777a20d Thanks, -- kou