Re: Proposal to provide the facility to set binary format output for specific OID's per session

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Proposal to provide the facility to set binary format output for specific OID's per session
Дата
Msg-id CADK3HHKbKryCyTGbpuoRjY9rnZ3ub=36_Anpc30MjBGB5d911w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Proposal to provide the facility to set binary format output for specific OID's per session  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Ответы Re: Proposal to provide the facility to set binary format output for specific OID's per session  (Jack Christensen <jack@jackchristensen.com>)
Список pgsql-hackers
Дерево обсуждения

Dave Cramer


On Sun, 24 Jul 2022 at 23:02, Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote:
At Fri, 22 Jul 2022 11:00:18 -0400, Dave Cramer <davecramer@gmail.com> wrote in
> As a proof of concept I provide the attached patch which implements the
> ability to specify which oids will be returned in binary format per
> session.
...
> Both the JDBC driver and the go driver can exploit this change with no
> changes. I haven't confirmed if other drivers would work without changes.

I'm not sure about the needs of that, but binary exchange format is
not the one that can be turned on ignoring the peer's capability.
I'm not sure what this means. The client is specifying which types it wants in binary format. 
  If
JDBC driver wants some types be sent in binary format, it seems to be
able to be specified in bind message.
To be clear it's not just the JDBC client; the original idea came from the author of go driver.
And yes you can specify it in the bind message but you have to specify it in *every* bind message which pretty much negates any advantage you might get out of binary format due to the extra round trip. 

Regards,
Dave 

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: log_line_prefix: make it possible to add the search_path
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: SLRUs in the main buffer pool, redux