Обсуждение: Query planning configuration and solid state drives

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.

Regards, Clodoaldo Pinto Neto

On Fri, May 30, 2008 at 11:43 AM, Clodoaldo
<clodoaldo.pinto.neto@gmail.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?

merlin

On Fri, May 30, 2008 at 9:43 AM, Clodoaldo
<clodoaldo.pinto.neto@gmail.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.

Well, random page cost should be about 1.0

Not sure other than that.

On Fri, May 30, 2008 at 2:55 PM, Clodoaldo
<clodoaldo.pinto.neto@gmail.com> wrote:
> 2008/5/30 Merlin Moncure <mmoncure@gmail.com>:
>> On Fri, May 30, 2008 at 11:43 AM, Clodoaldo
>> <clodoaldo.pinto.neto@gmail.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

2008/5/30 Merlin Moncure <mmoncure@gmail.com>:
> On Fri, May 30, 2008 at 11:43 AM, Clodoaldo
> <clodoaldo.pinto.neto@gmail.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.

Regards, Clodoaldo

>
> merlin
>