Re: Optimize update query

Поиск
Список
Период
Сортировка
От Willem Leenen
Тема Re: Optimize update query
Дата
Msg-id DUB104-W4140CECF592B7AC5F411768F430@phx.gbl
обсуждение исходный текст
Ответ на Re: Optimize update query  (Vitalii Tymchyshyn <tivv00@gmail.com>)
Ответы Re: Optimize update query  (Vitalii Tymchyshyn <tivv00@gmail.com>)
Список pgsql-performance

 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.
 

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

Предыдущее
От: Vitalii Tymchyshyn
Дата:
Сообщение: Re: Optimize update query
Следующее
От: Vitalii Tymchyshyn
Дата:
Сообщение: Re: Optimize update query