AW: Temp tables performance question

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: Temp tables performance question
Дата
Msg-id 11C1E6749A55D411A9670001FA687963368010@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список pgsql-hackers
> So you are not saying that INSERT on temp tables is any slower than
> ordinary tables, just that you think there is a way to make temp tables
> faster. 
> 
> My guess is that WAL is going to make INSERT's poor performance a
> non-issue.

I do not think that WAL in its first version can speed anything up,
it will rather slow things down.
I think that insert performance should be somewhere near "\copy" 
performance which is not so bad now. 
Thus it probably could be improved for both regular and temp tables.

Andreas

PS: I am off for a week now


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Temp tables performance question
Следующее
От: Tim Perdue
Дата:
Сообщение: Re: Some Improvement