Re: global temporary tables?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: global temporary tables?
Дата
Msg-id 3385.1086897822@sss.pgh.pa.us
обсуждение исходный текст
Ответ на global temporary tables?  ("David Parker" <dparker@tazznetworks.com>)
Список 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 по дате отправления:

Предыдущее
От: "David Parker"
Дата:
Сообщение: global temporary tables?
Следующее
От: Steve Wolfe
Дата:
Сообщение: Opteron scaling with PostgreSQL