Re: Query planning configuration and solid state drives

On Fri, May 30, 2008 at 2:55 PM, Clodoaldo
<clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> wrote:
> 2008/5/30 Merlin Moncure <mmoncure(at)gmail(dot)com>:
>> On Fri, May 30, 2008 at 11:43 AM, Clodoaldo
>> <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> wrote:
>>> What should be changed in the query planning configuration, if at all,
>>> if a ultrafast solid state drive would be used to host a whole
>>> database ? Specially if used in Raid 0 configurations.
>>
>> random_page_cost can probably be reduced...
>>
>> is this flash ssd?
>
> Yes, flash ssd.

Then you are probably aware that sequential speeds are similar to
spinning disk, random access is much, much. (much) better, and random
write is worse.

merlin