Postgres Pro
Downloads
Home   >   mailing lists

seqential vs random io - Mailing list pgsql-performance

From David Parker
Subject seqential vs random io
Date
Msg-id 07FDEE0ED7455A48AC42AC2070EDFF7C746598@corpsrv2.tazznetworks.com
Whole thread Raw
Responses Re: seqential vs random io
List pgsql-performance
Tree view
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
 

 

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Tuning planner cost estimates
Next
From: Yves Vindevogel
Date:
Subject: Re: Fwd: Index on table when using DESC clause