pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andreas Pflug <pgadmin@pse-consulting.de>
To: Dave Page <dpage@vale-housing.co.uk>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Magnus Hagander <mha@sollentuna.net>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Possible TODO item: copy to/from pipe
Date: Wed, 31 May 2006 22:54:58 +0200
Message-ID: <447E02A2.2040502@pse-consulting.de> (raw)
In-Reply-To: <C0A3BAC0.D203%dpage@vale-housing.co.uk>
References: <C0A3BAC0.D203%dpage@vale-housing.co.uk>

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




view thread (36+ messages)  latest in thread

Message-ID: <447E02A2.2040502@pse-consulting.de>
Permalink:  ../447E02A2.2040502@pse-consulting.de/
Also on:    postgresql.org/message-id/447E02A2.2040502@pse-consulting.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: pgadmin@pse-consulting.de, dpage@vale-housing.co.uk, tgl@sss.pgh.pa.us, mha@sollentuna.net
  Subject: Re: Possible TODO item: copy to/from pipe
  In-Reply-To: <447E02A2.2040502@pse-consulting.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox