I would tell him to go for the random, which is what most DBs would be by 
nature. What you need to understand will be the cache parameters, read/write 
cache amount, and stripe size, depending on your controller type and whatever 
it defaults to on these things.
 
Thanks,
Anjan

        -----Original Message----- 
        From: David Parker [mailto:[EMAIL PROTECTED] 
        Sent: Mon 5/23/2005 4:58 PM 
        To: pgsql-performance@postgresql.org 
        Cc: 
        Subject: [PERFORM] seqential vs random io
        
        
        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?

        - DAP
        
----------------------------------------------------------------------------------
        David Parker    Tazz Networks    (401) 709-5130
         
        

         


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to