Re: seqential vs random io

David,

> > I just got a question from one our QA guys who is configuring a RAID 10
> > disk that is destined to hold a postgresql database. The disk
> > configuration procedure is asking him if he wants to optimize for
> > sequential or random access. My first thought is that random is what we
> > would want, but then I started wondering if it's not that simple, and my
> > knowledge of stuff at the hardware level is, well, limited.....
> >
> > If it were your QA guy, what would you tell him?

Depends on the type of database.  OLTP or Web == random access.  Data
Warehouse == sequential access.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco