AW: Temp tables performance question

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Hannu Krosing'" <hannu(at)tm(dot)ee>, PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org>
Subject: AW: Temp tables performance question
Date: 2000-07-13 12:03:10
Message-ID: 11C1E6749A55D411A9670001FA68796336800E@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-07-13 13:21:05 Re: Temp tables performance question
Previous Message Hannu Krosing 2000-07-13 11:50:22 Re: AW: Temp tables performance question