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

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

---------- Forwarded message ----------
From: Adam Dec <ada...@gm...>
Date: 2013/7/16
Subject: Re: [Postgres-xc-developers] Data distribution by hash - general
question
To: Ashutosh Bapat <ash...@en...>


Cool! Thanks...but I was just wondering if there is some example DDL that I
could use? Any examples?


2013/7/16 Ashutosh Bapat <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
>