Re: R: feature proposal ... - Mailing list pgsql-hackers

From Chris Browne
Subject Re: R: feature proposal ...
Date
Msg-id 60irwupcrn.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to R: feature proposal ...  ("Paolo Magnoli" <pmagnoli@systemevolution.it>)
List pgsql-hackers
jd@commandprompt.com ("Joshua D. Drake") writes:
> Hans-Jürgen Schönig wrote:
>> no because a new is not a heap ...
>
> Why not use a function with a temporary table?
>
> That way you can pass a table parameter that
> is the temporary table with a select statement
> that you can populate the temp table with.

That means having to instantiate the temp table on disk "twice," once
as temp table, and once as the output file.

It would sure be nice to do it just once; that should lead to there
only being data written out once, which saves a lot on I/O.
-- 
(reverse (concatenate 'string "gro.mca" "@" "enworbbc"))
http://www.ntlug.org/~cbbrowne/spiritual.html
Rules  of  the Evil  Overlord  #59. "I  will  never  build a  sentient
computer smarter than I am." <http://www.eviloverlord.com/>


pgsql-hackers by date:

Previous
From: "Rafik Salama"
Date:
Subject: Re: postgresql clustering
Next
From: "Jonah H. Harris"
Date:
Subject: Re: postgresql clustering