Re: SSD database benchmarks

Поиск
Список
Период
Сортировка
От Guido Neitzer
Тема Re: SSD database benchmarks
Дата
Msg-id AC7BC19A-4DF3-4CC6-A0C9-7F0656BC8F53@event-s.net
обсуждение исходный текст
Ответ на SSD database benchmarks  (Greg Smith <gsmith@gregsmith.com>)
Ответы Re: SSD database benchmarks  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-performance
On 29.04.2008, at 12:55, Greg Smith wrote:

> This is the best write-up I've seen yet on quantifying what SSDs are
> good and bad at in a database context:
>
> http://www.bigdbahead.com/?p=37

They totally missed "mainly write" applications which most of my
applications are. Reads in a OLTP setup are typically coming from a
cache (or, like in our case an index like Solr) while writes go
through ... So you might get some decent IO from the SSD when the
database just started up without caches filled, but as long as your
cache hit ratio is good, it doesn't matter anymore after a couple of
minutes.

Nevertheless it's an interesting development.

cug

--
http://www.event-s.net


В списке pgsql-performance по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: SSD database benchmarks
Следующее
От: Greg Smith
Дата:
Сообщение: Re: SSD database benchmarks