| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
| Cc: | 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 03:45:36 |
| Message-ID: | CAFj8pRCejhxoaVj9t-Z8cWKw7G+3yru738530wv0Kwpy85dqQg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
2015-07-20 5:33 GMT+02:00 Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>:
> On 20/07/15 15:00, Pavel Stehule wrote:
>
>>
>>
>> 2015-07-19 21:39 GMT+02:00 Josh Berkus <josh(at)agliodbs(dot)com <mailto:
>> josh(at)agliodbs(dot)com>>:
>>
>> Pavel, All:
>>
>> Just to be clear, the idea of a global temp table is that the
>> table def
>> is available to all users, but the data is private to each session?
>>
>>
>> yes.
>>
>> Pavel
>>
>>
>> --
>> Josh Berkus
>> PostgreSQL Experts Inc.
>> http://pgexperts.com
>>
>>
>> Just wondering...
>
> 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
> -Gavin
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2015-07-20 05:31:10 | Re: Parallel Seq Scan |
| Previous Message | Gavin Flower | 2015-07-20 03:33:32 | Re: Implementation of global temporary tables? |