Message-ID: <447E02A2.2040502@pse-consulting.de>
Date: Wed, 31 May 2006 22:54:58 +0200
From: Andreas Pflug <pgadmin@pse-consulting.de>
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
To: Dave Page <dpage@vale-housing.co.uk>
CC: Tom Lane <tgl@sss.pgh.pa.us>, Magnus Hagander <mha@sollentuna.net>,
	pgsql-hackers@postgresql.org
Subject: Re: Possible TODO item: copy to/from pipe
References: <C0A3BAC0.D203%dpage@vale-housing.co.uk>
In-Reply-To: <C0A3BAC0.D203%dpage@vale-housing.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dave Page wrote:

>  It's not about a primarily GUI based OS not being able to do
>  everything a traditionally command line based OS can do on the
>  command line, it's about providing a solution that will work on
>  either and remain portable. Whilst I agree with your objection to
>  using pg_lzcompress,

Well, pg_lzcompress is in the backend for more than 6 years now, strange 
the objections arise now. However, a replacement for it might be a good 
idea, since apparently the fastest gzip algorithm is 3x faster for 10% 
better compression. TOAST write performance would probably profit 
significantly from a better algorithm.

I wonder what other use-cases exist for server side copy filters beyond 
compression.

Regards,
Andreas