Re: Optimize update query

Поиск
Список
Период
Сортировка
От Vitalii Tymchyshyn
Тема Re: Optimize update query
Дата
Msg-id CABWW-d2tzTQ8Wpk-sf6ZgPJpqzU3FAFSQfD523NzS=n7HqV7wg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Optimize update query  (Willem Leenen <willem_leenen@hotmail.com>)
Список pgsql-performance
SSDs are not faster for sequential IO as I know. That's why (with BBU or synchronious_commit=off) I prefer to have logs on regular HDDs.

Best reag


2012/11/30 Willem Leenen <willem_leenen@hotmail.com>

 Actually, what's the point in putting logs to ssd? SSDs are good for random access and logs are accessed sequentially. I'd put table spaces on ssd and leave logs on hdd
30 лист. 2012 04:33, "Niels Kristian Schjødt" <nielskristian@autouncle.com> напис.
Because SSD's are considered faster. Then you have to put the most phyisical IO intensive operations on SSD. For the majority of databases, these are the logfiles. But you should investigate where the optimum is for your situation.
 



--
Best regards,
 Vitalii Tymchyshyn

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

Предыдущее
От: Willem Leenen
Дата:
Сообщение: Re: Optimize update query
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Optimize update query