DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=RMl63TNFVMUmhhqloG+PjhfeiLUKxq58TBHLDQBBB2WrRYyfgTsw238J10ORf+VVTV
	1eb7tPtCf+Hp/e9ppWoAq6gJDXmmP7aQ3oMFVwXNUpcao0Lcw+XbXcc39TDzAPF9N8oo
	dwGTk0Abbpo5euyfJ61UfplMQPc56+gLsHHP8=
MIME-Version: 1.0
In-Reply-To: <1272200241.4161.1670.camel@ebony>
References: <u2o603c8f071004231952i36642ae6u9d6a7eae6eb6ff32@mail.gmail.com>
	<1272148142.4161.1598.camel@ebony>
	<g2x603c8f071004241601qbca333edmd384f9a0df596417@mail.gmail.com>
	<1272181795.4161.1604.camel@ebony>
	<i2z603c8f071004250350p35754194pd7821ce29c4461b3@mail.gmail.com>
	<1272200241.4161.1670.camel@ebony>
Date: Sun, 25 Apr 2010 11:35:18 -0400
Message-ID: <n2p603c8f071004250835x138a5924t47008cc91da09ddf@mail.gmail.com>
Subject: Re: global temporary tables
From: Robert Haas <robertmhaas@gmail.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1

On Sun, Apr 25, 2010 at 8:57 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> I don't think that quite works, because the standby might assign a
>> relfilenode number for a global temp table and then the master might
>> subsequently assign the same relfilenode number to a regular table.
>> We might be able to make that not matter, but it's far from obvious to
>> me that there are no gotchas there...
>
> That sounds fairly simple to solve.
>
> All I am saying is please include "working on the standby" as part of
> your requirement.

Well, I think I already basically stated my position on this, but let
me try to be more clear.  I'm not promising to work on any portion of
this project AT ALL or to have it done at any particular time.  I am
specifically not promising to do the extra work required to make it
work with Hot Standby, although I am also not saying that I won't.
Nobody has offered to fund any portion of this work, so there are no
guarantees, full stop.  Even if you could successfully convince a
critical mass of people on this list that the work should not be
committed without adding support for temp tables in Hot Standby mode,
the most likely result of that would be that I would give up and not
pursue this at all, rather than that I would agree to do that in
addition to solving all the problems already discussed.  And I don't
think you can even get that far, because I don't think too many people
here are going to say that we shouldn't add global temporary tables
unless we can also make them work with Hot Standby.

In all honesty, I would think that you would be happy about my
possibly implementing a flavor of temporary tables that would be
substantially more feasible to make work with Hot Standby than the
kind we have now, rather than (as you seem to be) complaining that I'm
not solving the entire problem.

...Robert