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

From Claudio Freire
Subject Re: Optimize kernel readahead using buffer access strategy
Date
Msg-id CAGTBQpb6ZxHyC0v6AfHyyv=erC4rsyDbp6u7EZoYLt1eAeF-hA@mail.gmail.com
Whole thread Raw
In response to Re: Optimize kernel readahead using buffer access strategy  (KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>)
List pgsql-hackers
On Tue, Jan 14, 2014 at 8:58 AM, KONDO Mitsumasa
<kondo.mitsumasa@lab.ntt.co.jp> wrote:
>
> In my past patch, it is significant bug which is mistaken caluculation of
> offset in posix_fadvise():-( However it works well without problem in
> pgbench.
> Because pgbench transactions are always random access...


Did you notice any difference?

AFAIK, when specifying read patterns (ie, RANDOM, SEQUENTIAL and stuff
like that), the offset doesn't matter. At least in linux.



pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: Custom Scan APIs (Re: Custom Plan node)
Next
From: Claudio Freire
Date:
Subject: Re: Optimize kernel readahead using buffer access strategy