Re: Optimize update query

Поиск
Список
Период
Сортировка
От Shaun Thomas
Тема Re: Optimize update query
Дата
Msg-id 50B8BD78.9050805@optionshouse.com
обсуждение исходный текст
Ответ на Re: Optimize update query  (Vitalii Tymchyshyn <tivv00@gmail.com>)
Список pgsql-performance
On 11/30/2012 02:37 AM, Vitalii Tymchyshyn wrote:

> Actually, what's the point in putting logs to ssd? SSDs are good for
> random access and logs are accessed sequentially.

While this is true, Niels' problem is that his regular HDs are getting
saturated. In that case, moving any activity off of them is an improvement.

Why not move the data to the SSDs, you ask? Because he bought two 3TB
drives. The assumption here is that a 256GB SSD will not have enough
space for the long-term lifespan of this database.

Either way, based on the iostat activity he posted, clearly there's some
other write stream happening we're not privy to.

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email


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

Предыдущее
От: Shaun Thomas
Дата:
Сообщение: Re: Optimize update query
Следующее
От: Bob Jolliffe
Дата:
Сообщение: deadlock under load