Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller

From: Scott Carey <scott(at)richrelevance(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>, Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
Cc: Matthew Wakeling <matthew(at)flymine(dot)org>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
Date: 2009-02-18 19:23:06
Message-ID: C5C1A01A.2856%scott@richrelevance.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

One thing to note, is that linux's md sets the readahead to 8192 by default instead of 128. I've noticed that in many situations, a large chunk of the performance boost reported is due to this alone.

On 2/18/09 12:57 AM, "Grzegorz Jaśkiewicz" <gryzman(at)gmail(dot)com> wrote:

have you tried hanging bunch of raid1 to linux's md, and let it do
raid0 for you ?
I heard plenty of stories where this actually sped up performance. One
noticeable is case of youtube servers.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Carey 2009-02-18 19:26:58 Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
Previous Message Scott Carey 2009-02-18 19:08:13 Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller