Re: Script to compute random page cost - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Script to compute random page cost
Date
Msg-id 20020909.165753.41634704.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Script to compute random page cost  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> OK, turns out that the loop for sequential scan ran fewer times and was
> skewing the numbers.  I have a new version at:
> 
>     ftp://candle.pha.pa.us/pub/postgresql/randcost
> 
> I get _much_ lower numbers now for random_page_cost.

I got:

random_page_cost = 1.047619

Linux kernel 2.4.18
Pentium III 750MHz
Memory 256MB
IDE HDD

(A notebook/SONY VAIO PCG-Z505CR/K)
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Script to compute random page cost
Next
From: Karel Zak
Date:
Subject: PREPARE code notes