| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Szymon Guz <mabewlun(at)gmail(dot)com> |
| Cc: | postgresql Forums <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: data compression in protocol? |
| Date: | 2011-06-23 03:26:18 |
| Message-ID: | 4E02B25A.60907@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gábor Farkas | 2011-06-23 07:20:20 | autovacuum ignores some tables |
| Previous Message | Steve Atkins | 2011-06-23 02:35:37 | Re: Tuning for a tiny database |