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

[Koichi S. <koi...@gm...>]

Many of the presentation materials available from Postgres-XC Wiki page
will help.   Please visit
http://postgresxc.wikia.com/wiki/Postgres-XC_Wiki

PGCon material in 2010 will come with table distribution in DBT-1 benchmark.

Regards;

----------
Koichi Suzuki


2013/7/15 Adam Dec <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
>
>
> ------------------------------------------------------------------------------
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>