Re: Implementation of global temporary tables?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Implementation of global temporary tables?
Дата
Msg-id 20150720090728.GG2301@postgresql.org
обсуждение исходный текст
Ответ на Re: Implementation of global temporary tables?  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Implementation of global temporary tables?  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Pavel Stehule wrote:
> 2015-07-20 5:33 GMT+02:00 Gavin Flower <GavinFlower@archidevsys.co.nz>:
> 
> > Would it be difficult to add the ability for one user to share the
> > contents with a list of named other users (roles)?
> 
> Probably it is possible, but not for temporary data - short data are in
> process memory, so it are not accessible from other sessions.
> 
> This sharing tables needs:
> 
> 1. some infrastructure to hold data about sharing - who can share with what
> 2. who will clean data? temporary data are cleaned on end of transaction or
> end of session
> 3. data should be saved in shared memory instead process memory
> 
> So it is possible, but partially different

To me this gets in the "crazy ideas" list.  Please add it to the TODO
page in the wiki, so that we're sure we never implement it.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Retain comments on indexes and constraints at ALTER TABLE ... TY
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Implementation of global temporary tables?