Re: data compression in protocol?

On 22/06/11 16:38, Szymon Guz wrote:
> Hi,
> I've got a lot of databases, unfortunately applications need to get a
> lot of data (a lot of means too much).
> The whole request takes about 3s, while pure explain analyze only 250ms.
> The amount of downloaded data cannot be changed.

What client are you using?

For libpq, as others have noted you can use OpenSSL-level compression.

For JDBC I think you're out of luck, as AFAIK the Java SSL
implementation doesn't support wire compression.

See this prior discussion on the topic:

http://postgresql.1045698.n5.nabble.com/Compression-on-SSL-links-td2261205.html

--
Craig Ringer