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

From Adrian Klaver
Subject Re: Performance of ByteA: ascii vs binary
Date
Msg-id e0ff1d45-2aff-4bbb-244e-358e8de65f5a@aklaver.com
Whole thread Raw
In response to Re: Performance of ByteA: ascii vs binary  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 3/21/19 6:49 AM, Tom Lane wrote:
> "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.

Yes, it would be nice to see the test code.

> 
>             regards, tom lane
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance of ByteA: ascii vs binary
Next
From: Eric Katchan
Date:
Subject: RE: Postgres 9.6 Slave Creation