AW: Re: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: Re: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3
Дата
Msg-id 11C1E6749A55D411A9670001FA6879633681B9@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Ответы Re: AW: Re: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> > 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 when no statistics are present.
Wasn't it something like a 5% estimate ? I did check
that behavior, since I was very concerned about that issue. 
Now, what is so different in his case?

Andreas


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: AW: AW: Re: tinterval - operator problems on AIX
Следующее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: AW: AW: Re: tinterval - operator problems on AIX