Re: [HACKERS] Fragmentation project

2007-04-27 Thread Marko Kreen
On 4/25/07, Gustavo Tonini <[EMAIL PROTECTED]> wrote: On 4/24/07, Marko Kreen <[EMAIL PROTECTED]> wrote: > On 4/23/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: > > Oh, you're talking about distributing partitions across different nodes > > and parallelizing queries. No, we don't do that toda

Re: [HACKERS] Fragmentation project

2007-04-25 Thread Josh Berkus
Gustavo, The pgpool is an interesting approach to this, but I think that the funcionality of inserting a record at a backend which will be "redirectioned" to other and verifying deadlocks under network demands in acquiring locks on the referenced records/tables in several hosts. Then, IMO, this

Re: [HACKERS] Fragmentation project

2007-04-25 Thread Gustavo Tonini
Marko, On 4/24/07, Marko Kreen <[EMAIL PROTECTED]> wrote: On 4/23/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: > Oh, you're talking about distributing partitions across different nodes > and parallelizing queries. No, we don't do that today. PL/Proxy actually works like that, only in small

Re: [HACKERS] Fragmentation project

2007-04-25 Thread Gustavo Tonini
Josh, On 4/23/07, Josh Berkus <[EMAIL PROTECTED]> wrote: Gustavo, > > 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. C

Re: [HACKERS] Fragmentation project

2007-04-24 Thread Marko Kreen
On 4/23/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: Oh, you're talking about distributing partitions across different nodes and parallelizing queries. No, we don't do that today. PL/Proxy actually works like that, only in smaller scope - for function calls only. General solution that par

Re: [HACKERS] Fragmentation project

2007-04-23 Thread Josh Berkus
Gustavo, > > 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... You migh

Re: [HACKERS] Fragmentation project

2007-04-23 Thread Gustavo Tonini
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 e

Re: [HACKERS] Fragmentation project

2007-04-23 Thread Heikki Linnakangas
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

Re: [HACKERS] Fragmentation project

2007-04-21 Thread Gustavo Tonini
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 matc

Re: [HACKERS] Fragmentation project

2007-04-19 Thread Heikki Linnakangas
Gustavo Tonini wrote: I'm thinking in project and implement "data fragmentation" based on catalogs inside pgcluster as my university final project. I would like suggestions and would be happy if anyone help me to define it. Sorry if this is the incorrect list...I had no answer on "pgcluster-gener

[HACKERS] Fragmentation project

2007-04-19 Thread Gustavo Tonini
Hello people, I'm thinking in project and implement "data fragmentation" based on catalogs inside pgcluster as my university final project. I would like suggestions and would be happy if anyone help me to define it. Sorry if this is the incorrect list...I had no answer on "pgcluster-general"... T