| From: | Curt Sampson <cjs(at)cynic(dot)net> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <nickf(at)ontko(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Ray Ontko <rayo(at)ontko(dot)com> |
| Subject: | Re: Script to compute random page cost |
| Date: | 2002-09-10 06:24:21 |
| Message-ID: | Pine.NEB.4.44.0209101520240.13186-100000@angelic.cynic.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 10 Sep 2002, Bruce Momjian wrote:
> Interesting that random time is increasing, while the others were
> stable. I think this may have to do with other system activity at the
> time of the test.
Actually, the random versus sequential time may also be different
depending on how many processes are competing for disk access, as
well. If the OS isn't maintaining readahead for whatever reason,
sequential access could, in theory, degrade to being the same speed
as random access. It might be interesting to test this, too.
cjs
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas SB SD | 2002-09-10 07:00:52 | Re: Proposal: Solving the "Return proper effected tuple |
| Previous Message | Christopher Kings-Lynne | 2002-09-10 06:23:29 | Re: Script to compute random page cost |