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 today.

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. Comments

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 smaller

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-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

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-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 example:

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 might

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

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