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

From Simon Riggs
Subject Re: Temporary tables under hot standby
Date
Msg-id CA+U5nMJ5qUNTQBNE3QDfhYevuZoqKvKZk0ug=-kCK+zWdA+TWg@mail.gmail.com
Whole thread Raw
In response to Re: Temporary tables under hot standby  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Thu, Apr 26, 2012 at 12:49 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:

>> I find it a rather elegant and well-thought-out kludge.
>
> Global temporary tables as a feature are far more than a kludge; I
> assume you're talking about that feature as a solution for the "no
> temporary tables on a hot standby" problem?  Even there I would
> consider GTT as more than a kludge.  They have been part of the SQL
> standard since at least the SQL-93 version, and have some very clean,
> clear uses.

Just to be clear, I haven't described GTTs as a kludge.

Again I say: if you want GTTs, build them. But don't build them
because they solve other problems as well, because they don't, and the
topic title of this thread is regrettably misnamed when we conflate
GTTs with $TOPIC. If Noah wishes to solve $TOPIC rather than build
GTTs then a different route is required.

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


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Temporary tables under hot standby
Next
From: Merlin Moncure
Date:
Subject: Re: 9.3: summary of corruption detection / checksums / CRCs discussion