From: Jeff Davis <pgsql@j-davis.com>
To: Gregory Stark <stark@enterprisedb.com>
Cc: Luke Lonergan <llonergan@greenplum.com>
Cc: Carlo Stonebanks <stonec.register@sympatico.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
Date: Mon, 10 Sep 2007 15:03:31 -0700
Message-ID: <1189461811.28581.17.camel@dogma.ljc.laika.com> (raw)
In-Reply-To: <87y7fekxga.fsf@oxford.xeocode.com>
References: <C30AF4C7.4230B%llonergan@greenplum.com>
<87y7fekxga.fsf@oxford.xeocode.com>
On Mon, 2007-09-10 at 22:44 +0100, Gregory Stark wrote:
> What I don't understand is the bit about "until Postgres gets AIO + the
> ability to post multiple concurrent IOs on index probes". Even with AIO your
> seek times are not going to be improved by wide raid stripes. And you can't
> possibly find the page at level n+1 before you've looked at the page at level
> n. Do you mean to be able to probe multiple index keys simultaneously? How
> does that work out?
>
I think he's referring to mirrors, in which there are multiple spindles
that can return a requested block. That could mitigate random I/O, if
the I/O is asynchronous and something intelligent (OS or controller) can
schedule it.
Regards,
Jeff Davis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: pgsql@j-davis.com, stark@enterprisedb.com, llonergan@greenplum.com, stonec.register@sympatico.ca
Subject: Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1
In-Reply-To: <1189461811.28581.17.camel@dogma.ljc.laika.com>
References: <C30AF4C7.4230B%llonergan@greenplum.com> <87y7fekxga.fsf@oxford.xeocode.com> <1189461811.28581.17.camel@dogma.ljc.laika.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox