Re: Optimize kernel readahead using buffer access strategy - Mailing list pgsql-hackers

From KONDO Mitsumasa
Subject Re: Optimize kernel readahead using buffer access strategy
Date
Msg-id 52B1087D.5060405@lab.ntt.co.jp
Whole thread Raw
In response to Re: Optimize kernel readahead using buffer access strategy  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Optimize kernel readahead using buffer access strategy
List 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 by date:

Previous
From: KONDO Mitsumasa
Date:
Subject: Re: pg_rewarm status
Next
From: Amit Kapila
Date:
Subject: Re: Logging WAL when updating hintbit