Re: What's the best way to use a Solid State HDD?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What's the best way to use a Solid State HDD?
Дата
Msg-id 5037.1092757842@sss.pgh.pa.us
обсуждение исходный текст
Ответ на What's the best way to use a Solid State HDD?  (Chris Gamache <cgg007@yahoo.com>)
Список pgsql-admin
Chris Gamache <cgg007@yahoo.com> writes:
> What would you do if you had a solid state hdd to use and you wanted
> to speed up PostgreSQL?

"Put WAL on it" is certainly the default answer.

If you are mainly concerned about speeding up writes, then this is also
the correct answer.  If you are mainly worried about read performance
then you might instead investigate pushing some critical tables/indexes
onto it.

            regards, tom lane

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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: What's the best way to use a Solid State HDD?
Следующее
От: Mark Gibson
Дата:
Сообщение: Re: [PHP] Kerberos, Apache2, mod_auth_kerb, PHP, and PostgreSQL in