pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ryan Bradetich <ryan_bradetich@hp.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: pgsql-sql@postgresql.org
Subject: Re: Use of index in 7.0 vs 6.5
Date: Tue, 30 May 2000 17:48:42 -0600
Message-ID: <3934535A.E971F988@hp.com> (raw)
References: <000e01bfc619$9fa5f9c0$2801007e@tpf.co.jp>
	<22559.959265549@sss.pgh.pa.us>
	<392DB9F3.2907B731@hp.com>
	<917.959299398@sss.pgh.pa.us>

Tom Lane wrote:

> Ryan Bradetich <ryan_bradetich@hp.com> 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





view thread (18+ messages)

Message-ID: <3934535A.E971F988@hp.com>
Permalink:  ../3934535A.E971F988@hp.com/
Also on:    postgresql.org/message-id/3934535A.E971F988@hp.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: ryan_bradetich@hp.com, tgl@sss.pgh.pa.us, Inoue@tpf.co.jp
  Subject: Re: Use of index in 7.0 vs 6.5
  In-Reply-To: <3934535A.E971F988@hp.com>
  References: <000e01bfc619$9fa5f9c0$2801007e@tpf.co.jp> <22559.959265549@sss.pgh.pa.us> <392DB9F3.2907B731@hp.com> <917.959299398@sss.pgh.pa.us> <3934535A.E971F988@hp.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox