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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
