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 case

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 default that