Re: [Postgres-xc-general] Exclude some tables to get sync while adding new coordinator and datanode

[鈴木 幸市 <ko...@in...>]

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...<mailto: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