Performance of ByteA: ascii vs binary
От | Thomas Güttler |
---|---|
Тема | Performance of ByteA: ascii vs binary |
Дата | |
Msg-id | c861b16d-29cb-47ee-6c22-e15f608928b6@thomas-guettler.de обсуждение исходный текст |
Ответы |
Re: Performance of ByteA: ascii vs binary
Re: Performance of ByteA: ascii vs binary Script which shows performance of ByteA: ascii vs binary Re: Performance of ByteA: ascii vs binary |
Список | 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 по дате отправления: