Re: Possible TODO item: copy to/from pipe

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Magnus Hagander <mha(at)sollentuna(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Possible TODO item: copy to/from pipe
Date: 2006-05-31 20:54:58
Message-ID: 447E02A2.2040502@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2006-05-31 21:04:18 Re: plperl's ppport.h out of date?
Previous Message Martijn van Oosterhout 2006-05-31 20:51:48 Re: Possible TODO item: copy to/from pipe