On Mon, Mar 19, 2012 at 5:40 PM, Venu Anuganti <venu_anuganti at yahoo.com> wrote:
> Doesn't that cause the complete copy of whole tables ?

No, if a node is already subscribed, SUBSCRIBE SET just changes how it
is to draw its data.  It doesn't need to start over from scratch.

While that behaviour is documented, if you read the documentation
carefully, I'd agree that the present behaviour isn't totally
intuitive.  I do not find it surprising that you would imagine that it
*would* lead to a complete copy.

There have been some private conversations where the idea has come up
that perhaps we should have add sort of RESHAPE SUBSCRIPTION command,
so that:

- SUBSCRIBE SET would be reserved for the "do a COPY of the complete
set of data"
- RESHAPE SUBSCRIPTION makes configuration changes.

I don't think we agreed conclusively that such a change ought to be
made, but it would be an improvement in the sense that it would fit
with your intuition.