Re: SSD performance

Поиск
Список
Период
Сортировка
От James Mansion
Тема Re: SSD performance
Дата
Msg-id 497EABB3.1050903@mansionfamily.plus.com
обсуждение исходный текст
Ответ на Re: SSD performance  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: SSD performance  (david@lang.hm)
Список pgsql-performance
Craig Ringer wrote:
> These devices would be interesting for a few uses, IMO. One is temp
> table space and sort space in Pg. Another is scratch space for apps
> (like Photoshop) that do their own VM management. There's also potential
>
Surely temp tables and sort space isn't subject to fsync and won't gain
that much since they
should stay in the OS cache?  The device will surely help seek- or
sync-bound tasks.

Doesn't that make it a good candidate for WAL and hot tables?

James


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

Предыдущее
От: david@lang.hm
Дата:
Сообщение: Re: [PERFORMANCE] Buying hardware
Следующее
От: david@lang.hm
Дата:
Сообщение: Re: SSD performance