Ohh i see i think i read the same earlier but still i can see data in newly
created node.
myDB=# select count(*) from accounts;
count
-------
79
(1 row)
And all datanode has same records, so i wonder from where data comes from
? is it synced automatically ?
On Thu, Apr 17, 2014 at 1:53 PM, 鈴木 幸市 <ko...@in...> wrote:
> While adding a coordinator or a datanode, only catalogs are copied. You
> should issue ALTER TABLE to each table to redistribute table rows.
> If you don’t want new datanode to be invoked in some tables, you can skip
> ALTER TABLE. Table rows will be distributed in the old set of
> datanodes.
>
> If you do it manually, it’s long process and there could be many
> pitfalls. Hope pgxc_ctl helps.
>
> Regards;
> ---
> Koichi Suzuki
>
> 2014/04/17 16:49、Juned Khan <jkh...@gm...> のメール：
>
> Hi All,
>
> I want to add few more coordinator and datnode in pgxc. during adding
> process whole database is being copy to new component.
>
> I have very large database around 8GB, in this database only one table is
> there which holds the large number of records.
>
> is there anyway to exclude such table while adding new coordinator or
> datanode using pgxc_ctl command ?
>
> I want to exclude some table just to make adding coordinator and datanode
> process smother and faster.
>
> Please suggest.
>
> --
> Thanks,
> Juned Khan
> <http://www.inextrix.com/>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech_______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>
>
--
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com
|
