[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>
wrote:

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

Thanks,
Pavan

-- 
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee
-------------- 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