| From: | Thomas Güttler <guettliml(at)thomas-guettler(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Performance of ByteA: ascii vs binary |
| Date: | 2019-03-18 14:33:17 |
| Message-ID: | c861b16d-29cb-47ee-6c22-e15f608928b6@thomas-guettler.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2019-03-18 14:36:46 | Re: postgresql-11 installation errors via deb package on ubuntu 16 |
| Previous Message | Vijaykumar Jain | 2019-03-18 14:24:01 | postgresql-11 installation errors via deb package on ubuntu 16 |