By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,199 Members | 1,440 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,199 IT Pros & Developers. It's quick & easy.

global temporary tables?

P: n/a
In our application we have a table that tracks network sessions. The
usage is:

1) create a session record
2) read/update the record several times during the session
3) delete the session record when the session ends

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.

Unfortunately, different network connections may be updating the same
session record at different times (connection pool), so the CREATE TABLE
TEMPORARY doesn't seem to fit the bill, since it's specific to a given
postgres session. It seems like the GLOBAL specifier would make the
temporary table a thing of beauty for our application, but the doc says
GLOBAL doesn't really do anything.

Are there any plans to implement GLOBAL for temporary tables in the near
future? If not, is it a matter of somebody stepping up to do it, or are
there practical/philosophical reasons for not doing it?

- DAP
================================================== ====
David Parker Tazz Networks (401) 709-5130

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"David Parker" <dp*****@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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #2

P: n/a
"David Parker" <dp*****@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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.