> 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