| From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
|---|---|
| To: | Matthias Urlichs <smurf(at)noris(dot)de> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bryan White <bryan(at)arcamax(dot)com>, Jesse Estevez <jestevez(at)travel-italy(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PG 7.0 is 2.5 times slower running a big report |
| Date: | 2000-05-26 10:41:07 |
| Message-ID: | 20000526034107.S28594@fw.wintelcom.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
* Matthias Urlichs <smurf(at)noris(dot)de> [000526 02:47] wrote:
> Hi,
>
> Bruce Momjian:
> > As I remember, Linux turns off file system prefetch if a seek is done.
>
> Correct (still so for Linux 2.4).
>
> > BSD file systems turn off prefetch only if prefetched blocks remain
> > unused.
>
> "Unused" is decided when?
> Do any, all, or some percentage of prefetched blocks need to be unused?
The statement:
> > BSD file systems turn off prefetch only if prefetched blocks remain
> > unused.
is false for FreeBSD afaik.
FreeBSD tracks how often sequential access happens and will retry it
as the file's access trend indicates. It can flip back and forth from
readahead and non-readahead.
--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-05-26 12:00:16 | Re: createdb -- alternate locations |
| Previous Message | Giles Lean | 2000-05-26 09:48:12 | Re: createdb -- alternate locations |