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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to