Zeugswetter Andreas SB wrote:
>
> > IMHO temporary tables could be made significantly faster than "ordinary"
> > as they are only accessed inside one session and thus have no need for
> > locking or even WAL as they could do with max 2 copies of the same row
> > the other of which can be discarded at end of transaction thereby making
> > it possible to provide much faster insert behaviour.
>
> I am somewhat confused. What does the max 2 copies issue have to do with
> inserts, where you only have one copy of the row anyway ?
You may want to rollback the transaction;
--------------
Hannu