Re: Using multi-row technique with COPY - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Using multi-row technique with COPY
Date
Msg-id 1133516346.2906.529.camel@localhost.localdomain
Whole thread Raw
In response to Re: Using multi-row technique with COPY  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, 2005-11-30 at 02:10 -0500, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > [...context omitted...]
> > We would need to flush all the blocks in the table out of cache at
> > commit time, for that table only.
> 
> This seems striking close to the Old Concept of temp tables, which
> we got rid of for good-and-sufficient reasons.  You might want to
> spend some time reviewing the archives before proposing that we
> reintroduce it.

My suggestion is that I use the same mechanism as was introduced for 8.1
with the CREATE TABLE AS SELECT statement.

Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: slow IN() clause for many cases
Next
From: Martijn van Oosterhout
Date:
Subject: Re: slow IN() clause for many cases