On 4/23/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
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.
Yes.This is the goal. Well, I will try it. I'll send the project
reports to this list. Comments will be valuable. Desire me good
luck...
Thanks,
Gustavo.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
