Re: Optimize kernel readahead using buffer access strategy

Поиск
Список
Период
Сортировка
От KONDO Mitsumasa
Тема Re: Optimize kernel readahead using buffer access strategy
Дата
Msg-id 52B1087D.5060405@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Optimize kernel readahead using buffer access strategy  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Optimize kernel readahead using buffer access strategy
Список pgsql-hackers
(2013/12/17 21:29), Simon Riggs wrote:
> These are interesting results. Good research.
Thanks!

> They also show that the benefit of this is very specific to the exact
> task being performed. I can't see any future for a setting that
> applies to everything or nothing. We must be more selective.
This patch is still needed some human judgement whether readahead is on or off.
But it might have been already useful for clever users. However, I'd like to 
implement adding more the minimum optimization.

> We also need much better benchmark results, clearly laid out, so they
> can be reproduced and discussed.
I think this feature is big benefit for OLTP, and it might useful for BI now.
BI queries are mostly compicated, so we will need to test more in some
situations. Printf debug is very useful for debugging my patch, and it will 
accelerate the optimization.

> Please keep working on this.
OK. I do it patiently.

Regards,
--
Mitsumasa KONDO
NTT Open Source Software Center



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

Предыдущее
От: KONDO Mitsumasa
Дата:
Сообщение: Re: pg_rewarm status
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Logging WAL when updating hintbit