Re: Request for comment on setting binary format output per session

From: Dave Cramer <davecramer(at)gmail(dot)com>
To: Jelte Fennema <postgres(at)jeltef(dot)nl>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff Davis <pgsql(at)j-davis(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Request for comment on setting binary format output per session
Date: 2023-10-10 12:24:28
Message-ID: CADK3HH+=WY2mvQTJY2Mr_HfOsmWRHn6WTw9RzU=oORCXVkiYNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 9 Oct 2023 at 17:11, Jelte Fennema <postgres(at)jeltef(dot)nl> wrote:

> On Mon, 9 Oct 2023 at 21:08, Dave Cramer <davecramer(at)gmail(dot)com> wrote:
> > So if we use <schema>.<type> would it be possible to have something like
> <builtin> which represents a set of well known types?
> > My goal here is to reduce the overhead of naming all the types the
> client wants in binary. The list of well known types is pretty long.
> > Additionally we could have a shorthand for removing a well known type.
>
> You're only setting this once in the lifetime of the connection right,
>

Correct

> i.e. right at the start (although pgbouncer could set it once per
> transaction in the worst case). It seems like it shouldn't really
> matter much to optimize the size of the "SET format_binary=..."
> command, I'd expect it to be at most 1 kilobyte. I'm not super opposed
> to having a shorthand for some of the most commonly wanted built-in
> types, but then we'd need to decide on what those are, which would add
> even more discussion/bikeshedding to this thread. I'm not sure the win
> in size is worth that effort.
>
It's worth the effort if we use schema.typename, if we use oids then I'm
not that invested in this approach.

Dave

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2023-10-10 12:33:05 Re: PGDOCS - add more links in the pub/sub reference pages
Previous Message Bowen Shi 2023-10-10 12:12:33 Re: Comparing two double values method