Re: Performance of ByteA: ascii vs binary

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Performance of ByteA: ascii vs binary
Дата
Msg-id e0ff1d45-2aff-4bbb-244e-358e8de65f5a@aklaver.com
обсуждение исходный текст
Ответ на Re: Performance of ByteA: ascii vs binary  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Performance of ByteA: ascii vs binary
Следующее
От: Eric Katchan
Дата:
Сообщение: RE: Postgres 9.6 Slave Creation