Re: Using multi-row technique with COPY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Using multi-row technique with COPY
Date: 2005-11-30 07:10:58
Message-ID: 14048.1133334658@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs <simon(at)2ndquadrant(dot)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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tino Wildenhain 2005-11-30 07:16:18 Re: BIN()
Previous Message Tom Lane 2005-11-30 07:05:41 Re: slow IN() clause for many cases