> I have a question about performance issues related to temporary tables.
>
> IIRC temporary tables were implemented as ordinary tables with some
> pre/post-processing to give them unique names so that they would not
> clash with similar-named tables from other sessions.
Right.
>
> Is this all that is done or has some work been done to improve their
> performance further?
>
> I'm mainly interested in INSERT performance as this is the area that is
> much slower than other operations.
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.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026