Re: Performance of ByteA: ascii vs binary - Mailing list pgsql-general

From Tom Lane
Subject Re: Performance of ByteA: ascii vs binary
Date
Msg-id 9587.1553176173@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance of ByteA: ascii vs binary  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Responses Re: Performance of ByteA: ascii vs binary  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
"Peter J. Holzer" <hjp-pgsql@hjp.at> writes:
> On 2019-03-20 13:20:57 +0100, Thomas Güttler wrote:
>> Strange. I saw a big difference.
>> What did you test?
>> I tested inserts.

> The graph with the quantiles was for selects.

Hmm, so there are two different code paths being considered here
-- the OP is apparently talking about the speed of bytea_in,
while the rest of us have been thinking about bytea_out.

The question about whether the text representation is hex or
"escape" style still applies, though.

            regards, tom lane


pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Performance of ByteA: ascii vs binary
Next
From: Adrian Klaver
Date:
Subject: Re: Performance of ByteA: ascii vs binary