John, > This would imply that an upgrade in drive RPM should be accompanied by > a decrease in random_page_cost, correct?
Maybe. Maybe not. Tom's Hardware did some Bonnie++ testing with a variety of new drives last year. They were moderately surprised to find that there were "faster" drives (i.e. higher RPM) which had lower real throughput due to poor onboard software and hardware, such as a small and slow onboard cache. So, it would be reasonable to assume that a 10,000 RPM Barracuda could support marginally lower random_page_cost than a 7,200 RPM Barracuda ... but that tells you nothing about a 10,000 RPM Maxtor Diamond (as an example). Also, many other factors influence real random_page_cost; the size and access pattern of your database is probably much more important than your RPM. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
