[Postgres-xl-developers] Addition of datanode master fails

Pavan Deolasee pavan.deolasee at gmail.com
Mon Jan 19 05:04:32 PST 2015

On Mon, Jan 19, 2015 at 4:20 PM, Ramanuj Hari <hari.ramanuj at gmail.com>

> Hi Pavan,
> Thank you for clarification.
> Would like to understand what is difference between below two command,
> assuming 'datanode1' is existing datanode, and have added 'datanode2' via
> 'add datanode master .. ' command, and want to redistribute table, given
> that af_device_l1 was initially created with 'DISTRIBUTE BY ROUNDROBIN':
> [1] ALTER TABLE af_device_l1 ADD NODE (datanode2);
> [2] ALTER TABLE af_device_l1 TO NODE (datanode1, datanode2), DISTRIBUTE BY
You are right. They do similar things. But the first one is more convenient
 when you need to just add (or remove) nodes without altering other
distribution properties.


Pavan Deolasee
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-developers-postgres-xl.org/attachments/20150119/095fe3be/attachment.htm>

More information about the Postgres-xl-developers mailing list