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
Ответ на
Список
Дерево обсуждения
Performance of ByteA: ascii vs binary Thomas Güttler <guettliml@thomas-guettler.de>
Re: Performance of ByteA: ascii vs binary Олег Самойлов <splarv@ya.ru>
Re: Performance of ByteA: ascii vs binary "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Performance of ByteA: ascii vs binary Thomas Güttler <guettliml@thomas-guettler.de>
Re: Performance of ByteA: ascii vs binary "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Performance of ByteA: ascii vs binary Tom Lane <tgl@sss.pgh.pa.us>
Re: Performance of ByteA: ascii vs binary Adrian Klaver <adrian.klaver@aklaver.com>
Re: Performance of ByteA: ascii vs binary Adrian Klaver <adrian.klaver@aklaver.com>
Re: Performance of ByteA: ascii vs binary Tom Lane <tgl@sss.pgh.pa.us>
minio server. Was: Performance of ByteA: ascii vs binary Thomas Güttler <guettliml@thomas-guettler.de>
Re: minio server. Was: Performance of ByteA: ascii vs binary Adrian Klaver <adrian.klaver@aklaver.com>
Re: minio server. Was: Performance of ByteA: ascii vs binary Thomas Güttler <guettliml@thomas-guettler.de>
Script which shows performance of ByteA: ascii vs binary Thomas Güttler <guettliml@thomas-guettler.de>
Re: Script which shows performance of ByteA: ascii vs binary Francisco Olarte <folarte@peoplecall.com>
Re: Script which shows performance of ByteA: ascii vs binary Kenneth Marshall <ktm@rice.edu>
Re: Script which shows performance of ByteA: ascii vs binary "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Script which shows performance of ByteA: ascii vs binary Thomas Güttler <guettliml@thomas-guettler.de>
Re: Script which shows performance of ByteA: ascii vs binary Adrian Klaver <adrian.klaver@aklaver.com>
Re: Script which shows performance of ByteA: ascii vs binary Francisco Olarte <folarte@peoplecall.com>
On 3/21/19 6:49 AM, Tom Lane wrote:
> "Peter J. Holzer"  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
Дата:
От: Eric Katchan
Дата:
FAQ