Re: [Postgres-xc-general] the cluster cost for normalized tables

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

HI Michael,
The distribution of data depends upon the distribution strategy used. In
Postgres-XC, we distribute data based on the hash/modulo of the given
column. It's usually advisable to choose the same distribution for the
tables which have equi-joins on their distribution columns.

Choosing the right distribution for the tables involved is an art. We need
the knowledge of table definitions and set of queries to decide the exact
distribution. If the queries are such that they join on collocated data,
the performance is greatly improved.

On Thu, Apr 19, 2012 at 4:56 PM, Michael Vitale <mic...@ar...> wrote:

>  Hi you most honorable cluster folks!
>
> Our company is moving from Oracle to PostgreSQL.  We initially thought we
> would be moving to MySQL Cluster, but an investigation of how clustering
> works in MySQL Cluster revealed that performance would suffer substantially
> since it is predicated on keys that segregate SQL-requested data to
> specific nodes and not to all or most of the nodes.  A highly normalized
> database would suffer in this situation where a result set would normally
> consist of rows gathered from most, if not all, of the back-end nodes.
>
> Do you all have the same problem with Clustered PostgreSQL (Postgres-XC)?
>
> Respectfully Yours,
>
> Michael Vitale
> ARIN DBA
> mic...@ar...
> 703-227-9885
>
>
>
> ------------------------------------------------------------------------------
> For Developers, A Lot Can Happen In A Second.
> Boundary is the first to Know...and Tell You.
> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
> http://p.sf.net/sfu/Boundary-d2dvs2
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>


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