From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Yann Le Moigne <ylemoigne(at)javatic(dot)fr> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: jsonb payload, compression and bandwith usage |
Date: | 2015-07-22 17:36:28 |
Message-ID: | CADK3HHJqF9f6tkrHQrJ4+7aDg3+84NOdfiXMgO=gNG3VNj1Nog@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Unfortunately no. The backend would need to understand this, and it doesn't
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 22 July 2015 at 12:45, Yann Le Moigne <ylemoigne(at)javatic(dot)fr> wrote:
> 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.
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
From | Date | Subject | |
---|---|---|---|
Next Message | Vitalii Tymchyshyn | 2015-07-23 15:09:14 | Re: jsonb payload, compression and bandwith usage |
Previous Message | Yann Le Moigne | 2015-07-22 16:45:39 | jsonb payload, compression and bandwith usage |