Re: Performance

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance
Date: 2011-04-14 00:37:05
Message-ID: 4DA641B1.4060707@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 04/13/2011 05:03 PM, Tom Lane wrote:
> That 4:1 ratio is based on some rather extensive experimentation that
> I did back in 2000. In the interim, disk transfer rates have improved
> quite a lot more than disk seek times have, and the CPU cost to process
> a page's worth of data has also improved compared to the seek time.
My experience is that at least a 1/1 is more appropriate.

JD

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2011-04-14 03:39:44 Re: Performance
Previous Message Tom Lane 2011-04-14 00:03:09 Re: Performance