Re: Temporary table performance?

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Michael A Nachbaur <mike(at)nachbaur(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Temporary table performance?
Date: 2003-06-26 17:23:39
Message-ID: 1056648218.7041.11.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)rbt(dot)ca>

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Barwick 2003-06-26 21:11:10 Re: UPDATE table SET col = (SELECT ...)
Previous Message Michael A Nachbaur 2003-06-26 16:14:41 Temporary table performance?