jsonb payload, compression and bandwith usage

Поиск
Список
Период
Сортировка
Искать
От
Yann Le Moigne
Тема
jsonb payload, compression and bandwith usage
Дата
Msg-id
3C154A5A-B064-4ABF-8DC3-281559D7F68F@javatic.fr
Список
Дерево обсуждения
jsonb payload, compression and bandwith usage Yann Le Moigne <ylemoigne@javatic.fr>
Re: jsonb payload, compression and bandwith usage Dave Cramer <pg@fastcrypt.com>
Re: jsonb payload, compression and bandwith usage Vitalii Tymchyshyn <vit@tym.im>
Re: jsonb payload, compression and bandwith usage Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
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.
В списке pgsql-jdbc по дате отправления
От: Dave Cramer
Дата:
Сообщение: Re: documentation download
От: Dave Cramer
Дата:
FAQ