AW: Temp tables performance question - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Temp tables performance question
Date
Msg-id 11C1E6749A55D411A9670001FA687963368010@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Temp tables performance question
Next
From: Tim Perdue
Date:
Subject: Re: Some Improvement