Re: Query plan looks OK, but slow I/O - settings advice?

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: Dan Harris <fbsd(at)drivefaster(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query plan looks OK, but slow I/O - settings advice?
Date: 2005-08-20 12:15:04
Message-ID: 20050820121504.GL19080@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Aug 20, 2005 at 12:52:08AM -0600, Dan Harris wrote:
>On Aug 19, 2005, at 12:55 AM, Jeffrey W. Baker wrote:
>> Have you considered booting your
>>machine with elevator=deadline?
>
>Although I'm not the OP for this problem, I thought I'd try it out.
>WOW.. this should be in a Pg tuning guide somewhere.
[snip]
>16-drive RAID 10

Yeah, the default scheduler tries to optimize disk access patterns for a
single-spindle setup, and actually makes things worse if you have a
device with multiple spindles.

Mike Stone

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message ohp 2005-08-20 12:18:29 index as large as table
Previous Message Marko Ristola 2005-08-20 11:17:54 Re: extremly low memory usage