Re: Hardware/OS recommendations for large databases ( - Mailing list pgsql-performance

From Vivek Khera
Subject Re: Hardware/OS recommendations for large databases (
Date
Msg-id 1F5BD2B1-8A75-498E-ADB7-8CB661066013@khera.org
Whole thread Raw
In response to Re: Hardware/OS recommendations for large databases (  ("Luke Lonergan" <llonergan@greenplum.com>)
Responses Re: Hardware/OS recommendations for large databases (  ("Luke Lonergan" <llonergan@greenplum.com>)
List pgsql-performance

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.

pgsql-performance by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Hardware/OS recommendations for large databases (
Next
From: Vivek Khera
Date:
Subject: Re: Hardware/OS recommendations for large databases (