Обсуждение: AW: Temp tables performance question
> 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 ? Andreas
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