Re: Question: merit / feasibility of compressing frontend - Mailing list pgsql-general

From Doug McNaught
Subject Re: Question: merit / feasibility of compressing frontend
Date
Msg-id m3k7nvy7l1.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Re: Question: merit / feasibility of compressing frontend  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Question: merit / feasibility of compressing frontend
List pgsql-general
Bruno Wolff III <bruno@wolff.to> writes:

> On Tue, Jul 16, 2002 at 01:59:10 -0700,
>   "Joshua D. Drake" <jd@commandprompt.com> wrote:
> >
> >   If you are dealing with 1 meg of text, across a distributed application
> > where the client connect via a VPN at 56k, we are talking 4 minutes. If we
> > compress and send it across that could be 30 seconds (mileage will vary).
>
> Shouldn't the VPN be doing compression?

Most VPNs (eg ones based on IPsec) work at the IP packet level, with
no knowledge of the streams at higher levels.  I don't think the IPsec
standard addresses compression at all--that's supposed to be handled
at the link layer (eg PPP) or at higher levels.

Even if it were there, packet-by-packet compression, or that provided
by a 56K modem link, isn't going to give you nearly as big a win as
compressing at the TCP stream level, where there is much more
redundancy to take advantage of, and you don't have things like packet
headers polluting the compression dictionary.

I'm not advocating zlib-in-PG, but it does seem that some people would
find it useful.

-Doug

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: brk() function and performance
Next
From: Robert Treat
Date:
Subject: Re: MySQL vs. PostgreSQL