Thread: AW: Temp tables performance question

AW: Temp tables performance question

From
Zeugswetter Andreas SB
Date:
> 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