pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndQuadrant.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: global temporary tables
Date: Mon, 26 Apr 2010 20:30:47 +0100
Message-ID: <1272310247.4161.5081.camel@ebony> (raw)
In-Reply-To: <n2p603c8f071004250835x138a5924t47008cc91da09ddf@mail.gmail.com>
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>
	<n2p603c8f071004250835x138a5924t47008cc91da09ddf@mail.gmail.com>

On Sun, 2010-04-25 at 11:35 -0400, Robert Haas wrote:

> 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.

The policy round here for some time has been that when we implement
things we make them work fully and seamlessly. I don't see why Hot
Standby would be singled out any more than any other feature, say
Windows support or tablespaces should be occasionally ignored.

People need to get used to the new feature set, just as we had to with
HOT, subtransactions, prepared transactions, Gist etc.. That may require
a thwack from various people, but the responsibility lies with the new
feature implementor, not the person supporting existing code. 

I fully understand your wish to implement a partial feature with caveats
because I have argued that many times myself. But I've come to realise
that the best way is to build things so they work cleanly across the
board. Other developers can plan projects in the knowledge that they can
build directly on firm foundations, not fill in the cracks. In the end
this comes down to a choice as developers, do we help each other by
doing a full job, or do we leave unexploded bombs for each other through
short-termism? Now I understand this better myself, I act differently
and accept objections if people think a fuller, more complete design is
what is needed. Recent demonstrations of that available, both objecting
and accepting.

Don't see this as an extra task, just see it as one of the many aspects
that will need to be considered when developing it. If you do that it
need not be additional work.

-- 
 Simon Riggs           www.2ndQuadrant.com




view thread (525+ messages)  latest in thread

Message-ID: <1272310247.4161.5081.camel@ebony>
Permalink:  ../1272310247.4161.5081.camel@ebony/
Also on:    postgresql.org/message-id/1272310247.4161.5081.camel@ebony

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: simon@2ndQuadrant.com, robertmhaas@gmail.com
  Subject: Re: global temporary tables
  In-Reply-To: <1272310247.4161.5081.camel@ebony>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox