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

From Zeugswetter Andreas SB
Subject AW: Temp tables performance question
Date
Msg-id 11C1E6749A55D411A9670001FA68796336800E@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> 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


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Temp tables performance question
Next
From: Hannu Krosing
Date:
Subject: Re: AW: Temp tables performance question