Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA04245; Mon, 28 Jun 93 20:19:48 -0700
Date: Mon, 28 Jun 93 20:19:48 -0700
Message-Id: <9306290319.AA04245@postgres.Berkeley.EDU>
From: bunting@pangaea.dme.nt.gov.au (Chris Bunting 61-89-895442)
Subject: Re: Access Methods
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

mao writes
> 
> if you do
> 
> 	replace pg_class (relpages = 10000, reltuples = 100000)
> 		where pg_class.relname = "obj_bbox"
> 
> you'll make the rtree less attractive, since the planner will assume
> that it'll have to do much more i/o to use the rtree than the btree.
> the down side is that you make the rtree less attractive than sequential
> scans, as well.  you can adjust the constants up or down to see what
> works for you.
> 					mike
> 

I still want to use the rtee access method in preference to sequential scan
but with less of a priority than btrees.

Could you suggest numbers to achieve this, or even some documentation that 
would allow me to work it out for myself.

Thanks
Chris Bunting
Database Manager
NT Dept of Mines and Energy
PO Box 2901
DARWIN NT 0801
AUSTRALIA
email    bunting.dme.nt.gov.au
voice    61-89-895442
fax      61-89-817861