Re: global temporary tables? - Mailing list pgsql-general

From Tom Lane
Subject Re: global temporary tables?
Date
Msg-id 3385.1086897822@sss.pgh.pa.us
Whole thread Raw
In response to global temporary tables?  ("David Parker" <dparker@tazznetworks.com>)
List pgsql-general
"David Parker" <dparker@tazznetworks.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

pgsql-general by date:

Previous
From: "David Parker"
Date:
Subject: global temporary tables?
Next
From: Steve Wolfe
Date:
Subject: Opteron scaling with PostgreSQL