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

From Dave Page
Subject Re: Script to compute random page cost
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B867BD@mail.vale-housing.co.uk
Whole thread Raw
In response to Script to compute random page cost  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Dell Inspiron 8100 laptop, 1.2GHz Pentium, 512Mb RAM, Windows XP Pro
CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown

random_page_cost = 0.924119

Regards, Dave.


> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent: 09 September 2002 07:14
> To: PostgreSQL-development
> Subject: Re: [HACKERS] Script to compute random page cost
>
>
>
> 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.


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Script to compute random page cost
Next
From: Tatsuo Ishii
Date:
Subject: Re: Script to compute random page cost