Re: Determining random_page_cost value - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Determining random_page_cost value
Date
Msg-id 435FA29E.7060805@dunslane.net
Whole thread Raw
In response to Determining random_page_cost value  ("Yohanes Santoso" <ysantoso@gmail.com>)
List pgsql-hackers

Yohanes Santoso wrote:

>I then ran it on various database size on a software 2 7200RPM IDE
>RAID-1 volume. I found out that if the dbase size (as from du
><dbase_dir>) is less than about 500M, I got a ratio of 4.5:1. On a
>larger dbase, 3GB, the ratio increases to 10:1.
>
>  
>

Surely this is going to be a function of table size, not database size, 
isn't it? Did you scale up the size of tables to get your 3Gb database?

cheers

andrew


pgsql-hackers by date:

Previous
From: Grzegorz Jaskiewicz
Date:
Subject: problem with custom Gist for custom type
Next
From: Tom Lane
Date:
Subject: Re: add_missing_from breaks existing views