Thank you for asking several times for a benchmark.
I wrote it now and it is visible: inserting random bytes into bytea is much slower,
if you use the psycopg2 defaults.
Here is the chart:
https://github.com/guettli/misc/blob/master/bench-bytea-inserts-postrgres.png
And here is the script which creates the chart:
https://github.com/guettli/misc/blob/master/bench-bytea-inserts-postrgres.py
Please let me know if there is something wrong or could get improved.
Regards,
Thomas Güttler
Am 18.03.19 um 15:33 schrieb Thomas Güttler:
> 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