On Wed, Nov 5, 2008 at 16:00, Kevin Grittner <[EMAIL PROTECTED]> 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... -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
