Re: [GENERAL] query optimiser changes 6.5->7.0

2000-06-01 Thread Joseph Shraibman
Tom Lane wrote: > > Also, 7.0.1, propagating now to an archive near you, contains some > fudge-factor twiddling to make it more willing to choose an indexscan. > We shall soon find out whether that made things better or worse for > typical uses... > > regards, tom lane O

Re: [GENERAL] query optimiser changes 6.5->7.0

2000-06-01 Thread Tom Lane
"Simon Hardingham" <[EMAIL PROTECTED]> writes: > I have run explain on the query and it shows that it is just > performed a sequential scan on version 7.0 > Seq Scan on gazet (cost.) > On the old version (6.5.1) it reports > Index Scan using gazet_index on gazet (cost= > Any suggesti