| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>, Josh Berkus <josh(at)agliodbs(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Zhaomo Yang <zhy001(at)cs(dot)ucsd(dot)edu>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Robert Haas <robertmhaas(at)gmail(dot)com> |
| Subject: | Re: Implementation of global temporary tables? |
| Date: | 2015-07-20 09:07:29 |
| Message-ID: | 20150720090728.GG2301@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Pavel Stehule wrote:
> 2015-07-20 5:33 GMT+02:00 Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2015-07-20 09:12:33 | Re: Implementation of global temporary tables? |
| Previous Message | Alvaro Herrera | 2015-07-20 08:41:46 | Re: [COMMITTERS] pgsql: Retain comments on indexes and constraints at ALTER TABLE ... TY |