Re: Query planning configuration and solid state drives - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Query planning configuration and solid state drives
Date
Msg-id b42b73150805301202n743ba71i1b5e31fc6c44fd81@mail.gmail.com
Whole thread Raw
In response to Query planning configuration and solid state drives  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: ravysters
Date:
Subject: libpostgres.a
Next
From: Clodoaldo
Date:
Subject: Re: Query planning configuration and solid state drives