Re: Performance of ByteA: ascii vs binary

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Performance of ByteA: ascii vs binary
Дата
Msg-id 8002ab5d-64b9-46c9-c2f4-62d03dd18cf3@aklaver.com
обсуждение исходный текст
Ответ на Performance of ByteA: ascii vs binary  (Thomas Güttler <guettliml@thomas-guettler.de>)
Ответы Re: Performance of ByteA: ascii vs binary
Список pgsql-general
Дерево обсуждения 
On 3/18/19 7:33 AM, Thomas Güttler wrote:
> I did some benchmarking and in my setup there was major
> performance difference.
> 
> I tested a ByteA column.

What was the test?

> 
> If I used ascii data the tests took 52 seconds.
> If I used random binary data the test took 250 seconds.
> 
> binary data is (roughly) five times slower than ascii data?
> 
> Is this a know fact, or is there something wrong with my benchmark?
> 
> I used Python and psycopg2.
> 
> Regards,
>    Thomas Güttler
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: postgresql-11 installation errors via deb package on ubuntu 16
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgresql-11 installation errors via deb package on ubuntu 16