Re: Patch : seq scan readahead (WIP)

From: Albert Cervera i Areny <albert(at)nan-tic(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>
Subject: Re: Patch : seq scan readahead (WIP)
Date: 2009-08-08 10:18:14
Message-ID: 200908081218.15188.albert@nan-tic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Boszormenyi Zoltan 2009-08-08 11:38:39 Re: Split-up ECPG patches
Previous Message Pierre Frédéric Caillaud 2009-08-08 09:18:30 Patch : seq scan readahead (WIP)