"Matthew" <matthew@xxxxxxxxxxx> writes: > Does Postgres issue requests to each random access in turn, waiting for > each one to complete before issuing the next request (in which case the > performance will not exceed that of a single disc), or does it use some > clever asynchronous access method to send a queue of random access > requests to the OS that can be distributed among the available discs? Sorry, it does the former, at least currently. That said, this doesn't really come up nearly as often as you might think. Normally queries fit mostly in either the large batch query domain or the small quick oltp query domain. For the former Postgres tries quite hard to do sequential i/o which the OS will do readahead for and you'll get good performance. For the latter you're normally running many simultaneous such queries and the raid array helps quite a bit. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
