Re: Patch : seq scan readahead (WIP) - Mailing list pgsql-hackers

From Albert Cervera i Areny
Subject Re: Patch : seq scan readahead (WIP)
Date
Msg-id 200908081218.15188.albert@nan-tic.com
Whole thread Raw
In response to Patch : seq scan readahead (WIP)  (Pierre Frédéric Caillaud<lists@peufeu.com>)
List pgsql-hackers
A Dissabte, 8 d'agost de 2009, Pierre Frédéric Caillaud va escriure:
> I guess it would need some experimenting with the values, and a
> per-tablespace setting, but since lots of people use Linux Software RAID1
> on servers, this might be interesting...
>
> You guys want to try it ?

Your tests involve only one user. What about having two (or more) users 
reading different tables? You're using both disks for one user for a 35% 
performance gain "only"...

>
> Patch attached.


-- 
Albert Cervera i Areny
http://www.NaN-tic.com
Mòbil: +34 669 40 40 18


pgsql-hackers by date:

Previous
From: Pierre Frédéric Caillaud
Date:
Subject: Patch : seq scan readahead (WIP)
Next
From: Boszormenyi Zoltan
Date:
Subject: Re: Split-up ECPG patches