minio server. Was: Performance of ByteA: ascii vs binary

From: Thomas Güttler <guettliml(at)thomas-guettler(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: minio server. Was: Performance of ByteA: ascii vs binary
Date: 2019-03-18 14:59:58
Message-ID: 4cb74bcb-ca70-3677-d6f8-87d859d660ff@thomas-guettler.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2019-03-18 15:17:28 Re: Camel case identifiers and folding
Previous Message Adrian Klaver 2019-03-18 14:51:01 Re: Permission to refresh materialized view