Re: Allow logical replication to copy tables in binary format

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Allow logical replication to copy tables in binary format
Дата
Msg-id 20220901222545.appl34sijiba7iyy@awork3.anarazel.de
обсуждение исходный текст
Ответ на Allow logical replication to copy tables in binary format  (Melih Mutlu <m.melihmutlu@gmail.com>)
Ответы Re: Allow logical replication to copy tables in binary format  (Melih Mutlu <m.melihmutlu@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Jonathan S. Katz"
Дата:
Сообщение: Re: SQL/JSON features for v15
Следующее
От: Nathan Bossart
Дата:
Сообщение: Re: postgres_fdw hint messages