From: | "Luke Lonergan" <llonergan(at)greenplum(dot)com> |
---|---|
To: | "James Mello" <james(at)haydrian(dot)com>, "William Yu" <wyu(at)talisys(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Hardware/OS recommendations for large databases ( |
Date: | 2005-11-16 06:11:39 |
Message-ID: | BFA00D9B.13C69%llonergan@greenplum.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
James,
On 11/15/05 11:07 AM, "James Mello" <james(at)haydrian(dot)com> wrote:
> Unless there was a way to guarantee consistency, it would be hard at
> best to make this work. Convergence on large data sets across boxes is
> non-trivial, and diffing databases is difficult at best. Unless there
> was some form of automated way to ensure consistency, going 8 ways into
> separate boxes is *very* hard. I do suppose that if you have fancy
> storage (EMC, Hitachi) you could do BCV or Shadow copies. But in terms
> of commodity stuff, I'd have to agree with Merlin.
It¹s a matter of good software that handles the distribution / parallel
query optimization / distributed transactions and management features.
Combine that with a gigabit ethernet switch and it works we routinely get
50x speedup over SMP on OLAP / Decision Support workloads.
Regards,
- Luke
From | Date | Subject | |
---|---|---|---|
Next Message | Joost Kraaijeveld | 2005-11-16 06:57:48 | Re: Performance PG 8.0 on dual opteron / 4GB / 3ware |
Previous Message | Luke Lonergan | 2005-11-16 06:07:53 | Re: Performance PG 8.0 on dual opteron / 4GB / 3ware |