Skip site navigation (1) Skip section navigation (2)

Re: [PATCH] COPY .. COMPRESSED

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] COPY .. COMPRESSED
Date: 2013-01-16 20:12:08
Message-ID: 20130116201208.GO16126@tamriel.snowman.net (view raw or flat)
Thread:
Lists: pgsql-hackers
* Peter Eisentraut (peter_e(at)gmx(dot)net) wrote:
> On 1/15/13 2:53 PM, Stephen Frost wrote:
> > You're right, to clarify, for *file_fdw*, which is a backend-only
> > operation, the popen patch is great (thought I made that clear before).
> 
> I would think that if we get writable FDWs, you would want file_fdw to
> go through zlib so that it can write directly to the file.

With the popen patch, I expect it could be defined as '|gzip >
myfile.gz'..  I believe that patch did that.  It'd be ideal to add
support for that to file_fdw also, certainly.  That shouldn't be hard as
file_fdw is essentially a wrapper around backend COPY already and this
would just be adding a few additional options to pass through.

	Thanks,

		Stephen

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2013-01-16 20:13:50
Subject: Re: CF3+4
Previous:From: Stephen FrostDate: 2013-01-16 20:07:14
Subject: Re: Parallel query execution

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group