From: | "Gustavo Tonini" <gustavotonini(at)gmail(dot)com> |
---|---|
To: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
Cc: | "pgsql-hackers list" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Fragmentation project |
Date: | 2007-04-23 23:44:44 |
Message-ID: | 9c31dd0d0704231644h301295e1y8e2878cc0345cc86@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 4/23/07, Heikki Linnakangas <heikki(at)enterprisedb(dot)com> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2007-04-24 00:09:27 | Re: Fragmentation project |
Previous Message | Alvaro Herrera | 2007-04-23 23:33:11 | Re: Better error message for select_common_type() |