Re: Performance penalty when requesting text values in binary format

2020-05-19 Thread Jack Christensen
On Mon, May 18, 2020 at 7:07 AM Laurenz Albe wrote: > Did you profile your benchmark? > It would be interesting to know where the time is spent. > Unfortunately, I have not. Fortunately, it appears that Tom Lane recognized this as a part of another issue and has prepared a patch. https://www.po

Re: Performance penalty when requesting text values in binary format

2020-05-18 Thread Laurenz Albe
On Sat, 2020-05-16 at 20:12 -0500, Jack Christensen wrote: > I'm the creator of the PostgreSQL driver pgx (https://github.com/jackc/pgx) > for the Go language. > I have found significant performance advantages to using the extended > protocol and binary format > values -- in particular for types

Performance penalty when requesting text values in binary format

2020-05-16 Thread Jack Christensen
I'm the creator of the PostgreSQL driver pgx (https://github.com/jackc/pgx) for the Go language. I have found significant performance advantages to using the extended protocol and binary format values -- in particular for types such as timestamptz. However, I was recently very surprised to find th