Re: [GENERAL] Parallel DB architechture

2009-03-30 Thread Ow Mun Heng
>>On Behalf Of Asko Oja >>Hello >>We use plProxy (RUN ON ALL) to run queries in parallel. >>We split our database into 16 shards and distributed it over 4 servers. >>So now we are running queries on 16 cpu's in parallel :) Wow.. query time improved How many fold? Any idea? -- Sent via pgsql-ge

Re: [GENERAL] Parallel DB architechture

2009-03-30 Thread Asko Oja
Hello We use plProxy (RUN ON ALL) to run queries in parallel. We split our database into 16 shards and distributed it over 4 servers. So now we are running queries on 16 cpu's in parallel :) regards, Asko On Mon, Mar 30, 2009 at 9:20 AM, aravind chandu wrote: > Hello, > >I would li

[GENERAL] Parallel DB architechture

2009-03-29 Thread aravind chandu
Hello, I would like to implement parallel DB Architecture in postgres.I came across various parallel architectures shared memory,shared disk,shared nothing,hierarchical.But I am unaware of how to implement one of these in real time system.Can you guys help me in this aspect?