Postgres Pro
Downloads
Home   >   mailing lists

Re: Implementation of global temporary tables? - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Implementation of global temporary tables?
Date
Msg-id CAFj8pRCejhxoaVj9t-Z8cWKw7G+3yru738530wv0Kwpy85dqQg@mail.gmail.com
Whole thread Raw
In response to Re: Implementation of global temporary tables?  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Responses Re: Implementation of global temporary tables?
List pgsql-hackers
Tree view


2015-07-20 5:33 GMT+02:00 Gavin Flower <GavinFlower@archidevsys.co.nz>:
On 20/07/15 15:00, Pavel Stehule wrote:


2015-07-19 21:39 GMT+02:00 Josh Berkus <josh@agliodbs.com <mailto:josh@agliodbs.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

pgsql-hackers by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Implementation of global temporary tables?
Next
From: Amit Kapila
Date:
Subject: Re: Parallel Seq Scan