On Wed, Nov 5, 2008 at 16:00, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> 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).
Well arguably you can already do this...
create tablespace ram location '/dev/shm/';
create temp table (junk int) tablespace ram;
In theory because only one backend needs the temp table we should be
able to use mmap() to fake it being a file as well without to much
trouble. But im sure I am missing something...