long transfer time for binary data

From: Johannes <jotpe(at)posteo(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: long transfer time for binary data
Date: 2016-01-20 21:29:07
Message-ID: 569FFC23.2020202@posteo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I noticed transferring a large object or bytea data between client and
server takes a long time.
For example: An image with a real size of 11 MB could be read on server
side (explain analyze) in 81ms. Fine.

But on client side the result was completed after 6.7 seconds without
ssl compression and 4.5 seconds with ssl compression (both via 100MBit
ethernet).

SSL compression seems to be not a good idea anymore, since this had
become a security risk. Its still possible with pgadmin, but afaik not
with java/jdbc .

Are there any other solutions available to display my images in my
client application more quickly? Or are there planned improvements to
postgresql (transferring the real binary data)?

Best regards
Johannes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message AI Rumman 2016-01-20 23:22:44 How to stop autovacuum for daily partition old tables
Previous Message (Daniel Stolf) 2016-01-20 20:55:09 adding a bdr node using bcv backup