RAM-only temporary tables

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: RAM-only temporary tables
Date: 2008-11-05 23:00:56
Message-ID: 4911D148.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

An idea for a possible enhancement to PostgreSQL: allow creation of a
temporary table without generating any disk I/O. (Creating and
dropping a three-column temporary table within a database transaction
currently generates about 150 disk writes).

If some circumstances don't make it feasible to always do this as a
RAM-only operation, perhaps a clause could be added to the CREATE
TEMPORARY TABLE syntax to specify this behavior along with whatever
limitations on the temporary table are required for this to work.
(For example, maybe this is only feasible if the table will be dropped
by the end of the transaction?)

-Kevin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bernd Helmle 2008-11-05 23:12:31 Re: Patch for ALTER DATABASE WITH TABLESPACE
Previous Message Martijn van Oosterhout 2008-11-05 22:07:39 Re: [WIP] In-place upgrade