Re: Query planning configuration and solid state drives

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Query planning configuration and solid state drives
Дата
Msg-id b42b73150805301202n743ba71i1b5e31fc6c44fd81@mail.gmail.com
обсуждение исходный текст
Ответ на Query planning configuration and solid state drives  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: ravysters
Дата:
Сообщение: libpostgres.a
Следующее
От: Clodoaldo
Дата:
Сообщение: Re: Query planning configuration and solid state drives