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

From Thomas Güttler
Subject Performance of ByteA: ascii vs binary
Date
Msg-id c861b16d-29cb-47ee-6c22-e15f608928b6@thomas-guettler.de
Whole thread Raw
Responses Re: Performance of ByteA: ascii vs binary  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Performance of ByteA: ascii vs binary  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Script which shows performance of ByteA: ascii vs binary  (Thomas Güttler <guettliml@thomas-guettler.de>)
Re: Performance of ByteA: ascii vs binary  (Олег Самойлов <splarv@ya.ru>)
List pgsql-general
I did some benchmarking and in my setup there was major
performance difference.

I tested a ByteA column.

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


-- 
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines


pgsql-general by date:

Previous
From: Vijaykumar Jain
Date:
Subject: postgresql-11 installation errors via deb package on ubuntu 16
Next
From: Adrian Klaver
Date:
Subject: Re: postgresql-11 installation errors via deb package on ubuntu 16