Hi Tom,
Tom Lane wrote:
>
> Doug McNaught <doug@wireboard.com> writes:
> > I think the big obstacle to putting compression into PG is needing to
> > extend the FE/BE protocol for negotiating compression, and the possible
> > client compatibility issues that raises. We already have SSL
> > negotiation working, though...
>
> Yup. Seems like a more useful exercise would be to lobby the SSL people
> to include compression as an option in SSL connections. That would
> solve the problem not only for PG, but every other application that uses
> SSL ...
We can all see the merits of having a compressed data stream, especially
in those situations where the byte count if more important than a CPU
cost.
However, I'd like to point out that SSL isn't feasible to use in all
situations, so having to enable SSL to gain compression would be a pain.
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
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@postgresql.org)
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi