Re: Determining random_page_cost value

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Yohanes Santoso <ysantoso(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Determining random_page_cost value
Date: 2005-10-26 15:37:02
Message-ID: 435FA29E.7060805@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-10-26 15:41:56 Re: add_missing_from breaks existing views
Previous Message Grzegorz Jaskiewicz 2005-10-26 15:30:25 problem with custom Gist for custom type