Re: Parallel DB architechture - Mailing list pgsql-general

From Asko Oja
Subject Re: Parallel DB architechture
Date
Msg-id ecd779860903300052r42298336wbf05f8f992c21ba4@mail.gmail.com
Whole thread Raw
In response to Parallel DB architechture  (aravind chandu <avin_friends@yahoo.com>)
Responses Re: Parallel DB architechture  ("Ow Mun Heng" <MunHeng.Ow@wdc.com>)
List pgsql-general
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:
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?


pgsql-general by date:

Previous
From: Stuart Bishop
Date:
Subject: pgstattuple triggered checkpoint failure and database outage?
Next
From: Eric Smith
Date:
Subject: Re: running two servers on one machine