Parallel DB architechture

Started by aravind chanduabout 17 years ago3 messagesgeneral
Jump to latest
#1aravind chandu
avin_friends@yahoo.com

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?

#2Asko Oja
ascoja@gmail.com
In reply to: aravind chandu (#1)
Re: Parallel DB architechture

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 <avin_friends@yahoo.com>wrote:

Show quoted text

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?

#3Ow Mun Heng
MunHeng.Ow@wdc.com
In reply to: Asko Oja (#2)
Re: Parallel DB architechture

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?