jsonb payload, compression and bandwith usage

From: Yann Le Moigne <ylemoigne(at)javatic(dot)fr>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: jsonb payload, compression and bandwith usage
Date: 2015-07-22 16:45:39
Message-ID: 3C154A5A-B064-4ABF-8DC3-281559D7F68F@javatic.fr
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

Currently, I use PgObject to store a document in a jsonb column.

But in my usecase ; network bandwith is limited and jsonb as string is quite heavy. (Between 2-5 Mbyte).
Something like gzip is very effective to reduce the size of the payload (about 70%).

So is there any support for compression in current jdbc driver ?
If yes, is it active by default ? (I don’t see any option in driver documentation to enable ou disable it).
If no, is there an alternative way to handle it ? (like handling json (de)compression at application level, et create some sort of automatic conversion on postgres side).

Thanks for your attention,
Best Regards,
Yann.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2015-07-22 17:36:28 Re: jsonb payload, compression and bandwith usage
Previous Message Dave Cramer 2015-07-22 14:04:04 Re: documentation download