Re: Possible TODO item: copy to/from pipe - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: Possible TODO item: copy to/from pipe
Date
Msg-id 447E02A2.2040502@pse-consulting.de
Whole thread Raw
In response to Re: Possible TODO item: copy to/from pipe  (Dave Page <dpage@vale-housing.co.uk>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Possible TODO item: copy to/from pipe
Next
From: Andrew Dunstan
Date:
Subject: Re: plperl's ppport.h out of date?