[Postgres-xc-developers] Data distribution by hash - general question

[Adam D. <ada...@gm...>]

Hi!

My topology: 2 machines (on each machine 1 master coordinator and 1 master
datannode)

Lets say that I have a table A which has
- one-to-many relation with table B
- one-to-many relation to table C
- one-to-one relation with table D

I would like to distribute it in the cluster. All I have to do is to put
DISTRIBUTE BY HASH(id); in each of the tables while creating them?
id - primary key

In my example Table A is like a root of the graph. How to create such a
"graph of tables" to be shure
that when I will invoke a select with joins all the proceesin will be done
only on the one node.
I do not want to replicate all the data.

Where can I read about data distribution in Postgres XC? Do you have any
examples that I could look at?


Regards,

Adam Dec