Received: from clio.trends.ca (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA67906 for ; Tue, 30 May 2000 20:07:47 -0400 (EDT) (envelope-from ryan_bradetich@hp.com) Received: from atlrel1.hp.com (atlrel1.hp.com [156.153.255.210]) by clio.trends.ca (8.9.3+Sun/8.9.3) with ESMTP id TAA26541 for ; Tue, 30 May 2000 19:48:43 -0400 (EDT) Received: from l3107mxr.atl.hp.com (l3107mxr.atl.hp.com [15.19.254.19]) by atlrel1.hp.com (Postfix) with ESMTP id 3440E54; Tue, 30 May 2000 19:48:44 -0400 (EDT) Received: from hpbs5000.boi.hp.com (hpbs5000.boi.hp.com [15.56.8.201]) by l3107mxr.atl.hp.com (Postfix) with ESMTP id F100B4FD8A; Tue, 30 May 2000 18:48:42 -0400 (EDT) Received: from hp.com (rbrad@hpb50023.boise.itc.hp.com [15.62.176.50]) by hpbs5000.boi.hp.com with ESMTP (8.8.6 (PHNE_17135)/8.7.3 TIS 5.0.1) id RAA07260; Tue, 30 May 2000 17:48:42 -0600 (MDT) Message-ID: <3934535A.E971F988@hp.com> Date: Tue, 30 May 2000 17:48:42 -0600 From: Ryan Bradetich X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.3.99-pre3 i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane Cc: Hiroshi Inoue , pgsql-sql@postgresql.org Subject: Re: Use of index in 7.0 vs 6.5 References: <000e01bfc619$9fa5f9c0$2801007e@tpf.co.jp> <22559.959265549@sss.pgh.pa.us> <392DB9F3.2907B731@hp.com> <917.959299398@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/211 Tom Lane wrote: > Ryan Bradetich writes: > > This worked great! Is their a place I can change the default to 3? > > I do not want to change all the scripts to include this :) > > See src/include/optimizer/cost.h. However, I am currently thinking of > taking Hiroshi's advice instead. Lowering RANDOM_PAGE_COST seems like > a bad idea --- if anything, we might want to raise it ;-) > > >>>> Or how about changing current fudge factor ? > >>>> For example,from 0.5 to 0.2 which is the fudge factor of attdisbursion > >>>> calculation. > >> > >> Yes, that's another way --- and probably more defensible than changing > >> random_page_cost, now that I think about it. Unfortunately it's a > >> hardwired constant and so not as easily experimented with :-(. > > > Can you give me more information about this? I do not have a problem > > re-compiling the database and performing more testing if you would like. > > The fudge factor in question is currently 0.5, and is used in two places > in src/backend/utils/adt/selfuncs.c (looks like lines 193 and 212 in 7.0 > sources). I was thinking of dropping it to 0.25 or 0.1. > > regards, tom lane Tom and Hiroshi, I modified the backend to 0.1 and this has been working great! Thanks again for the suggestion, and I'll let you know if we run into a problem. Thanks again! Ryan