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

Andrew Dunstan wrote:
> David Fetter wrote:

> >As with "in-place upgrades,"[1] the compelling use case is being short
> >on disk space.  For somebody with a multi-TB (or whatever figure
> >sounds big this week) PostgreSQL database, it may be impossible to get
> >space for twice or more that.  Giving people the option to stream
> >COPYs through a pipe would alleviate a lot of pain.
> 
> But why is that hugely better than piping psql output to gzip?

psql output has already travelled over the network.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.