From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Thomas Güttler <guettliml(at)thomas-guettler(dot)de>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: minio server. Was: Performance of ByteA: ascii vs binary |
Date: | 2019-03-18 16:52:20 |
Message-ID: | ab65a4a3-d619-b6cc-fea1-efdb4790a6f9@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 3/18/19 7:59 AM, Thomas Güttler wrote:
>
>
> Am 18.03.19 um 15:49 schrieb Tom Lane:
>> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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?
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Gustavsson Mikael | 2019-03-18 17:11:35 | SV: Permission to refresh materialized view |
Previous Message | Rob Sargent | 2019-03-18 15:17:28 | Re: Camel case identifiers and folding |