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 по дате отправления