Horton

Re: [PATCH] COPY .. COMPRESSED

Claudio Freire <klaussfreire@gmail.com>

View thread View on postgr.es
From: Claudio Freire <klaussfreire@gmail.com>
To: Stephen Frost <sfrost@snowman.net>
Cc: Peter Eisentraut <peter_e@gmx.net>, Tom Lane <tgl@sss.pgh.pa.us>, Simon Riggs <simon@2ndquadrant.com>, PostgreSQL-Dev <pgsql-hackers@postgresql.org>
Date: 2013-01-15T14:55:31Z
Lists: pgsql-hackers 
On Mon, Jan 14, 2013 at 11:33 PM, Stephen Frost <sfrost@snowman.net> wrote:
> Now, protocol-level on-the-wire compression
> is another option, but there's quite a few drawbacks to that and quite a
> bit of work involved.  Having support for COPY-based compression could
> be an answer for many cases where on-the-wire compression is desirable.

Like?

Postgres' packetized protocol lends itself quite well for this kind of
thing. It could even be done on a packet-by-packet basis. The only
drawback I see, is that it pretty much rules out piping through
arbitrary commands (a protocol needs to be very clearly defined).