Re: idea: global temp tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: idea: global temp tables
Дата
Msg-id 3617.1240931888@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: idea: global temp tables  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: idea: global temp tables  ("vacuum" <vacuum@quantentunnel.de>)
Re: idea: global temp tables  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: idea: global temp tables  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Maybe we could make this work by fiddling with a different smgr -- on
> it, smgr_sync would be a noop, as would smgr_immedsync, and we could
> kludge something up to truncate relations during recovery.

Interesting thought but I think it falls down on pg_statistic.

One comment I've got is that we have already concluded that the spec's
GLOBAL/LOCAL TEMP TABLE distinction is not related to cross-session
persistence of the table definitions, but rather to module visibility
which is a concept we have not got (yet).  Ergo, we should not use the
phrase "global temp table" for these things.  Not sure what to suggest
instead.  Perhaps call them "session tables" instead of "temp tables"?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: Clean shutdown and warm standby
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Clean shutdown and warm standby