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

[Ashutosh B. <ash...@en...>]

HI Adam,
To answer your particular question about distribution of tables for
effective joins, please watch my presentation here
http://www.youtube.com/watch?v=g_9CYat8nkY
The slides can be found at
http://wiki.postgresql.org/images/f/f6/PGXC_Scalability_PGOpen2012.pdf.

HTH.


On Mon, Jul 15, 2013 at 6:33 PM, Adam Dec <ada...@gm...> wrote:

> 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
>
>


-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Postgres Database Company