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

[Michael V. <mic...@ar...>]

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