Thread: Parallel DB architechture
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?
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?
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
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 <avin_friends@yahoo.com> wrote:
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?
>>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?