Re: Allow logical replication to copy tables in binary format - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Allow logical replication to copy tables in binary format
Date
Msg-id 20220901222545.appl34sijiba7iyy@awork3.anarazel.de
Whole thread Raw
In response to Allow logical replication to copy tables in binary format  (Melih Mutlu <m.melihmutlu@gmail.com>)
Responses Re: Allow logical replication to copy tables in binary format
List pgsql-hackers
Hi,

On 2022-08-10 18:03:56 +0300, Melih Mutlu wrote:
> To copy tables, COPY command is used and that command supports copying in
> binary. So it seemed to me possible to copy in binary for tablesync too.
> I'm not sure if there is a reason to always copy tables in text format.

It'd be good to collect some performance numbers justifying this. I'd expect
decent gains if there's e.g. a bytea or timestamptz column involved.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: Re: SQL/JSON features for v15
Next
From: Nathan Bossart
Date:
Subject: Re: postgres_fdw hint messages