Re: Optimize kernel readahead using buffer access strategy

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Mitsumasa KONDO <kondo(dot)mitsumasa(at)gmail(dot)com>
Cc: KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Optimize kernel readahead using buffer access strategy
Date: 2013-12-12 14:05:01
Message-ID: CA+U5nMJQ==AvTxypAdnNQbfdwPS3xraX2mzmz5Mv7Na1fNdq9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 12 December 2013 13:43, Mitsumasa KONDO <kondo(dot)mitsumasa(at)gmail(dot)com> wrote:

>> Your tests seem to relate to pgbench. Do we have tests on more BI related
>> tasks?
>
> Yes, off-course! We will need another benchmark test before conclusion of
> this patch.
> What kind of benchmark do you have?

I suggest isolating SeqScan and IndexScan and BitmapIndex/HeapScan
examples, as well as some of the simpler TPC-H queries.

But start with some SeqScan and VACUUM cases.

--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message MauMau 2013-12-12 14:12:04 pg_stat_statements shows too short COMMIT time
Previous Message Mitsumasa KONDO 2013-12-12 13:46:28 Re: Time-Delayed Standbys