Re: Temporary tables under hot standby - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Temporary tables under hot standby
Date
Msg-id CA+U5nMKtHUOQjwQFuD87-3X3ze3KMsOs_OTj_Vm=j61EiNLRWQ@mail.gmail.com
Whole thread Raw
In response to Re: Temporary tables under hot standby  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Wed, May 2, 2012 at 4:14 PM, Bruce Momjian <bruce@momjian.us> wrote:

> I think if implementing global temporary tables only for hot standby
> user (#7), it might be of limited usefulness, but the ability to avoid
> system table churn (#1) means global temporary tables would have a wide
> usefulness, even without hot standby use.

Yes, many parts of Noah's proposal would be useful for normal running.
And as Jim points out, they are SQL Standard, as well as supported by
Oracle and DB2, so again GTTs would hit that TODO item.

And Noah's proposal does take us more than 50%, maybe 80% of the way
to what I think would be most useful for HS.

So overall, I do encourage the proposal.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: clog double-dip in heap_hot_search_buffer
Next
From: Simon Riggs
Date:
Subject: Re: clog double-dip in heap_hot_search_buffer