Обсуждение: AW: Temp tables performance question

Поиск
Список
Период
Сортировка

AW: Temp tables performance question

От
Zeugswetter Andreas SB
Дата:
> 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