Re: Temporary table performance? - Mailing list pgsql-sql

From Rod Taylor
Subject Re: Temporary table performance?
Date
Msg-id 1056648218.7041.11.camel@jester
Whole thread Raw
In response to Temporary table performance?  (Michael A Nachbaur <mike@nachbaur.com>)
List pgsql-sql
> 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

pgsql-sql by date:

Previous
From: Michael A Nachbaur
Date:
Subject: Temporary table performance?
Next
From: Gunter Diehl
Date:
Subject: Rules: passing new/old to functions