Re: [Postgres-xc-general] Questions about Postgres-XC

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

XC replicates schema at all the nodes.   It has all the information how each table is sharded or replicated.   So, schema itself is not sharded but tables can be sharded.

Hope this makes sense.

Regards;
---
Koichi Suzuki

2014/05/29 20:27、Alan Bryant <ala...@hd...<mailto:ala...@hd...>> のメール：



- Can we shard on schema? (i.e. put some schemas in one location and other schemas in different locations, sharded the same way rows are?) Or if not, can we shard one table, and have functions execute on the same node as some controlling row?

No.

Interesting. This leaves us with the "one big table" approach, just spread across the data nodes. Aren't there performance issues with having massive individual tables? What techniques exist to help with this?

Partitioning is one option I guess, using a different (but compatible) scheme than the sharding key, perhaps a different bitmask on the same key.

Another question is upgrade. We use schemas primarily to make logical upgrades possible while online, but what about Postgres-XC itself... what is the upgrade model for Postgres-XC? (say, between major PostgreSQL versions)

Thanks!
-Alan

------------------------------------------------------------------------------
Time is money. Stop wasting it! Get your web API in 5 minutes.
www.restlet.com/download<http://www.restlet.com/download>
http://p.sf.net/sfu/restlet_______________________________________________
Postgres-xc-general mailing list
Pos...@li...
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general