Re: Fragmentation project

Gustavo Tonini wrote:
> Well, I'm thinking in define (maybe via SQL) a set of servers as a
> cluster and make the fragmentation rules based on "select clauses",
> storing this "configuration" in a specific catalog in global schema.
> For example: when a record is inserted in a server which not store
> this fragment (no rule matches), it will be automatically moved do the
> correct server (the server who matches that record), transparently to
> the user. This process involves transaction management and a lot more
> validations.
>
> A propose is:
>
> create partition <name> on <site> as <select clause>
>
> This create a replication in this site with the rules of the select clause.
>
> We can provide, for example, users create a foreign key in a site
> referencing a table who stored in other(s). In this case, the foreign
> key will be created in global schema but the validations of the local
> schema's would be managed by DRDBMS.
>
> These are my ideas. Is this supported today?

Oh, you're talking about distributing partitions across different nodes
and parallelizing queries. No, we don't do that today.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com