From: | "Luke Lonergan" <llonergan(at)greenplum(dot)com> |
---|---|
To: | "Vivek Khera" <vivek(at)khera(dot)org>, "Postgresql Performance" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Hardware/OS recommendations for large databases ( |
Date: | 2005-11-18 16:16:39 |
Message-ID: | BFA33E67.1404D%llonergan@greenplum.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Vivek,
On 11/18/05 8:07 AM, "Vivek Khera" <vivek(at)khera(dot)org> wrote:
>
> On Nov 18, 2005, at 10:13 AM, Luke Lonergan wrote:
>
>> Still, there is a CPU limit here this is not I/O bound, it is CPU limited
>> as evidenced by the sensitivity to readahead settings. If the filesystem
>> could do 1GB/s, you wouldn¹t go any faster than 244MB/s.
>
> Yeah, and mysql would probably be faster on your trivial queries. Try
> concurrent large joins and updates and see which system is faster.
That¹s what we do to make a living. And it¹s Oracle that a lot faster
because they implemented a much tighter, optimized I/O path to disk than
Postgres.
Since you asked, we bought the 5 systems as a cluster and with Bizgres MPP
we get close to 400MB/s per machine on complex queries.
- Luke
From | Date | Subject | |
---|---|---|---|
Next Message | Luke Lonergan | 2005-11-18 16:17:48 | Re: Hardware/OS recommendations for large databases ( |
Previous Message | Alan Stange | 2005-11-18 16:13:44 | Re: Hardware/OS recommendations for large databases ( |