Re: Question: merit / feasibility of compressing frontend

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Justin Clift <justin(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Doug McNaught <doug(at)wireboard(dot)com>, Bruno Wolff III <bruno(at)wolff(dot)to>, Chris Albertson <chrisalbertson90278(at)yahoo(dot)com>, Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question: merit / feasibility of compressing frontend
Date: 2002-07-17 08:32:10
Message-ID: Pine.LNX.4.44.0207170129290.30489-100000@crazypenguins.commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> If someone's willing to put the time into this, then compression without
> SSL feels like a good idea. Not everyone uses SSL. Bad network latency

Well, we are already putting the time into it ;). I expect to have it
complete by the end of the week. If people like we can keep in touch about
it.

Sincerely,

Joshua Drake

> has a very undesirable effect on the establishment of SSL connections,
> and this is especially of interest in those cases where people need to
> get short "bursty" amounts of SQL data across a connection as fast as
> possible. Aka, client using a frontend app to remote databases over a
> modem, and not using persistent connections.
>
> Establishment of an individual SSL session using OpenSSL can take over a
> second in this case. Not consistently-always, but I had to time it (on
> fast hardware too) for a contract recently when deciding on network
> layer transports.
>
> Hope this gives some decent food for thought.
>
> :-)
>
> Regards and best wishes,
>
> Justin Clift
>
> > regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2002-07-17 08:32:44 Re: Logging SQL queries?
Previous Message Ben Liblit 2002-07-17 08:16:58 Re: dropping anonymous constraints