| From: | "Matthias Urlichs" <smurf(at)noris(dot)de> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | 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 09:05:54 |
| Message-ID: | 20000526110554.G11082@noris.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
--
Matthias Urlichs | noris network GmbH | smurf(at)noris(dot)de | ICQ: 20193661
The quote was selected randomly. Really. | http://smurf.noris.de/
--
If hyperspace did not already exist, science fiction writers would have had to
invent it
-Peter Oakley
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Giles Lean | 2000-05-26 09:48:12 | Re: createdb -- alternate locations |
| Previous Message | Bill Barnes | 2000-05-26 08:46:50 | Creating new user in vers 7.02 and pgaccess |