| Lists: | pgsql-general |
|---|
| From: | aravind chandu <avin_friends(at)yahoo(dot)com> |
|---|---|
| To: | postgresql Forums <pgsql-general(at)postgresql(dot)org> |
| Subject: | Parallel DB architechture |
| Date: | 2009-03-30 06:20:48 |
| Message-ID: | 323098.30993.qm@web31405.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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?
| From: | Asko Oja <ascoja(at)gmail(dot)com> |
|---|---|
| To: | aravind chandu <avin_friends(at)yahoo(dot)com> |
| Cc: | postgresql Forums <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Parallel DB architechture |
| Date: | 2009-03-30 07:52:37 |
| Message-ID: | ecd779860903300052r42298336wbf05f8f992c21ba4@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(at)yahoo(dot)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?
>
>
| From: | "Ow Mun Heng" <MunHeng(dot)Ow(at)wdc(dot)com> |
|---|---|
| To: | "Asko Oja" <ascoja(at)gmail(dot)com>, "aravind chandu" <avin_friends(at)yahoo(dot)com> |
| Cc: | "postgresql Forums" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Parallel DB architechture |
| Date: | 2009-03-30 08:08:34 |
| Message-ID: | D1109E8B2FB53A45BDB60F8145905CE901348538@wdmyexbe03.my.asia.wdc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
>>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?