Am 18.03.19 um 17:52 schrieb Adrian Klaver:
> On 3/18/19 7:59 AM, Thomas Güttler wrote:
>>
>>
>> Am 18.03.19 um 15:49 schrieb Tom Lane:
>>> Adrian Klaver <adrian.klaver@aklaver.com> writes:
>>>> On 3/18/19 7:33 AM, Thomas Güttler wrote:
>>>>> If I used ascii data the tests took 52 seconds.
>>>>> If I used random binary data the test took 250 seconds.
>>>
>>> This doesn't seem terribly surprising in bytea_output = escape
>>> mode. Probably with bytea_output = hex the performance would
>>> be less data-dependent.
>>
>> Thank you for your fast reply.
>>
>> I guess we will use a minio server to store the blobs.
>
> According to this:
>
> http://initd.org/psycopg/docs/usage.html?highlight=bytea#adapt-binary
>
> psycopg2 will use 'hex' by default.
>
> Have you tried the test outside Python/psycopg2 e.g in psql to see if the performance hit still exists?
No, I did not test it outside Python/psycopg2.
Since our code will use Python/psycopg2 I did not run a test outside.
The decision was made. Now I am busy learning minio. I use it for the first time.
Regards,
Thomas Güttler
--
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines