Re: AW: Temp tables performance question - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: AW: Temp tables performance question
Date
Msg-id 396DACFE.403C0F0A@tm.ee
Whole thread Raw
In response to AW: Temp tables performance question  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: Temp tables performance question
Next
From: Bruce Momjian
Date:
Subject: Re: Temp tables performance question