Re: Hardware/OS recommendations for large databases (

From: Vivek Khera <vivek(at)khera(dot)org>
To: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hardware/OS recommendations for large databases (
Date: 2005-11-18 16:07:04
Message-ID: 1F5BD2B1-8A75-498E-ADB7-8CB661066013@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2005-11-18 16:13:12 Re: weird performances problem
Previous Message Vivek Khera 2005-11-18 16:05:16 Re: Hardware/OS recommendations for large databases (