Re: global temporary tables?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Parker" <dparker(at)tazznetworks(dot)com>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: global temporary tables?
Date: 2004-06-10 20:03:42
Message-ID: 3385.1086897822@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"David Parker" <dparker(at)tazznetworks(dot)com> writes:
> Update activity on this table is going to be pretty intense, and the
> transient nature of the data makes it a good candidate for a temporary
> and/or in-memory table.

> Are there any plans to implement GLOBAL for temporary tables in the near
> future?

No. If you are going to allow multiple backends to access it, I don't
think there are any optimizations possible. Use a regular table.
You can just DROP the thing when you're done.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2004-06-10 21:09:25 Opteron scaling with PostgreSQL
Previous Message David Parker 2004-06-10 19:29:43 global temporary tables?