Re: index on a box

Around 11:08 on Jun 21, 2001, Tom Lane said:

# If you say "SET enable_seqscan TO off", and repeat the EXPLAIN, do you
# get an indexscan plan?

Seq Scan on tmp  (cost=100000000.00..100002500.84 rows=30434 width=92)

# I don't recommend doing such a SET for production purposes, but if
# this works then the problem is just inaccurate selectivity/cost
# estimation. I see that the on_pb operator has no selectivity estimator
# defined at all :-( ... as a quick hack, try setting its oprrest and
# oprjoin to be areasel and areajoinsel.

    I'm not sure what you just said.  :)

--
SPY                      My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________