Обсуждение: jsonb payload, compression and bandwith usage
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 somesort of automatic conversion on postgres side). Thanks for your attention, Best Regards, Yann.
Unfortunately no. The backend would need to understand this, and it doesn't
On 22 July 2015 at 12:45, Yann Le Moigne <ylemoigne@javatic.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
How about SSL? It may be an overkill, but SSL usually has some sort of compression.
Ср, 22 лип. 2015 14:23 Dave Cramer <pg@fastcrypt.com> пише:
Unfortunately no. The backend would need to understand this, and it doesn'tOn 22 July 2015 at 12:45, Yann Le Moigne <ylemoigne@javatic.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
> How about SSL? I think it was discussed here: http://www.postgresql.org/message-id/CAMsr+YFh1J72bckTZe0te+eJCJ=JnW-g-q_KQhFg_thVdxKxDw@mail.gmail.com TLDR: "real answer is probably to just add PostgreSQL protocol-level support for compression, rather than trying to (ab)use SSL for it." Another option is SSH port forwarding (SSH can do transparent compression). Vladimir