Re: Performance of ByteA: ascii vs binary

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Performance of ByteA: ascii vs binary
Дата
Msg-id 9587.1553176173@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Performance of ByteA: ascii vs binary  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Ответы Re: Performance of ByteA: ascii vs binary
Список 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 по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Performance of ByteA: ascii vs binary
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Performance of ByteA: ascii vs binary