Thread: Temporary table performance?

Temporary table performance?

From
Michael A Nachbaur
Date:
Hello everyone,

In the Intranet application I've been building over the past 9 months, I have 
developed quite a beast of a search.  I've asked for help here in the past on 
performance tuning it, and have come to the conclusion that I've gotten it as 
tweaked as I can without seeking the counsel of a shamen.

What I'm looking at doing is improving in-page performance. In a nutshell, how 
expensive is it to create a temporary table?  I'd like to do something like:

CREATE TEMP TABLE SearchResults AS [......];

I could then do some queries against the temporary table without having to 
regenerate the results every time I want to show a "Page 299 of 500" toolbar.

Would I be better off just sucking this data into an in-memory data structure, 
or can I use a temp table as an easy-to-use alternative?

-- 
/* Michael A. Nachbaur <mike@nachbaur.com>* http://nachbaur.com/pgpkey.asc*/

...[Arthur] leapt to his feet like an author hearing the phone ring...



Re: Temporary table performance?

From
Rod Taylor
Date:
> I could then do some queries against the temporary table without having to
> regenerate the results every time I want to show a "Page 299 of 500" toolbar.

Performance wise temp tables are the same as a regular table but without
WAL on the table contents.

> Would I be better off just sucking this data into an in-memory data structure,
> or can I use a temp table as an easy-to-use alternative?

You are probably better off using a cursor.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc