postgresql tcp data compression

Is there any internal method in postgresql to enable data compression over psql connection开发者_高级运维 over tcp socket.

I can also use some other method that are not internal to postgresql, such as ssh compression or any other vpn compression. However, this may increase complexity.

Regards,

It seems that starting with postgresql 9.2 there is an sslcompression option that defaults to true. However it requires that the used openssl library is build with zlib support to work. For instance the openssl binaries in the windows enterprise DB installers do not have this support. Also both sides have ofcourse to support it!

When I was asking the same question about two months ago, the only answer was: use SSH. However I haven't checked that as we managed to split column into two and download about 200kB per query instead of 20MB and it was enough.

We had big rows in a table (with JSON inside). Your problem can be slightly different. Maybe you are getting rows you don't need? I've seen that too many times: get all rows from a table, sort in application, then get the first 10... when it is enough to use order by and limit.