AW: Temp tables performance question

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: Temp tables performance question
Дата
Msg-id 11C1E6749A55D411A9670001FA68796336800E@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Temp tables performance question
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: AW: Temp tables performance question