Re: Compression - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Compression
Date
Msg-id 10263.1254511589@sss.pgh.pa.us
Whole thread Raw
In response to Re: Compression  (Eric Jain <eric.jain@gmail.com>)
Responses Re: Compression  (Eric Jain <eric.jain@gmail.com>)
List pgsql-jdbc
Eric Jain <eric.jain@gmail.com> writes:
> So it looks like compression was supported in their commercial version
> of PostgreSQL. When it was discontinued, the people working on the
> open source version of PostgreSQL apparently didn't see any point in
> incorporating the code to support compression, so now there is none
> :-(

I seem to remember that that was discussed and the conclusion was that
it was reinventing the wheel --- you could perfectly well use ssl/ssh
compression if you needed it, and you'd want encryption too anyway
in most plausible scenarios where compression makes sense.  (If the
network trip is long enough to justify compression, it's likely not
all secure.)

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Eric Jain
Date:
Subject: Re: Compression
Next
From: Robert Nicholson
Date:
Subject: How do you batch insert and still obtain identity?