| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Temporary tables under hot standby |
| Date: | 2012-05-03 13:19:01 |
| Message-ID: | CAHyXU0xyox=B0XsCkSrZVDhpw89_KzynwueSD8bRos3-U6PVPQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, May 3, 2012 at 4:11 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> which seems to me to be actually harder than just rewriting as derived
> table and isn't an option on Microstrategy etc, hence my observation
> that GTTs don't help HS much. What I would like to see, one day, is
> for temp tables to work without any changes.
yes. except (global) temp tables can:
*) be updated with data not derived from permanent tables (think:
session management, etc)
*) outlive a single transaction
*) be indexed independently of the sourcing tables
*) be referred to from multiple queries (you can simulate this with
CTE, but that approach obviously has limits)
of course, temp tables that would 'just work' would be wonderful.
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2012-05-03 13:31:17 | Re: How hard would it be to support LIKE in return declaration of generic record function calls ? |
| Previous Message | Andres Freund | 2012-05-03 13:08:19 | outdated comment in heapam.c |