Re: Postgres on SSD

On 08/12/2011 04:24 PM, Vick Khera wrote:
> 2011/8/10 Ondrej Ivanič<ondrej(dot)ivanic(at)gmail(dot)com>:
>
>> Ups! Well spotted Tomas! The actual values are:
>> random_page_cost = 2
>> seq_page_cost = 1
>>
>>
> With the SSD I would set these to the same value of 1. That's what I do.
>

That probably makes sense on your RAMSAN. Sequential access on FusionIO
drives is at least 3X as fast as completely random though, and
worst-case it can be even slower relative to what a sequential scan can
deliver. It's not the >50X difference seen on regular drives, but
there's an easily measurable gap. I'm not sure if it's that the flash
cells deliver stuff faster when you read a sequential series from the
same cell of flash, or if it's just that there's less physical IOs
happening.

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us