[Postgres-xl-general] Adding new datanode and "ALTER TABLE REDISTRIBUTE"
pavan.deolasee at gmail.com
Tue Sep 16 10:35:34 PDT 2014
On Tue, Sep 16, 2014 at 10:57 PM, Dennis <dennisr at visi.com> wrote:
> Hi all, I am confused by the current documentation. I have just added
> new datanode to my cluster and now I need to redistribute the tables to the
> new node. The documentation says I need to "Redistribute existing data
> by using ALTER TABLE REDISTRIBUTE. The new datanode is now ready.”
> (From: http://files.postgres-xl.org/documentation/add-node-datanode.html)
> But there doesn’t seem to be a “ATLER TABLE REDISTRIBUTE” command. So I
> am wondering if the correct command is to issue an “ALTER TABLE foo ADD
> NODE(new_node);” command and if that will redistribute the table and it’s
> indexes. I am using both replicated and round robin distribution schemes
AFAIK “ALTER TABLE foo ADD NODE(new_node);” is the correct way to
redistribute data. You can use ALTER TABLE foo DISTRIBUTE BY <scheme> to
change the distribute scheme itself (e.g. changing distribution column or
type). But to redistribute data to a new set of nodes, one should use
ADD/DELETE NODE mechanism.
I would also suggest using the latest sources from the git repository since
we have fixed couple of bugs in this area.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgres-xl-general