Re: Sequential Scan Read-Ahead - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Sequential Scan Read-Ahead
Date
Msg-id 20020425123429E.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Sequential Scan Read-Ahead  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Curt Sampson <cjs@cynic.net> writes:
> > Grabbing bigger chunks is always optimal, AFICT, if they're not
> > *too* big and you use the data. A single 64K read takes very little
> > longer than a single 8K read.
> 
> Proof?

Long time ago I tested with the 32k block size and got 1.5-2x speed up
comparing ordinary 8k block size in the sequential scan case.
FYI, if this is the case.
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sequential Scan Read-Ahead
Next
From: Bruce Momjian
Date:
Subject: Re: Sequential Scan Read-Ahead