Re: AW: [HACKERS] Re: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3

2001-01-17 Thread Tom Lane
Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes: > More importantly, PostgreSQL 6.5.3 works very, very well without > VACUUM'ing. >> >> 6.5 effectively assumes that "foo = constant" will select exactly one >> row, if it has no statistics to prove otherwise. > I thought we had agreed upon a de

AW: [HACKERS] Re: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3

2001-01-17 Thread Zeugswetter Andreas SB
> > More importantly, PostgreSQL 6.5.3 works very, very well without > > VACUUM'ing. > > 6.5 effectively assumes that "foo = constant" will select exactly one > row, if it has no statistics to prove otherwise. I thought we had agreed upon a default that would still use the index in the above ca