Re: query optimiser changes 6.5->7.0

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: query optimiser changes 6.5->7.0
Дата
Msg-id 393736A9.ECF133AC@selectacast.net
обсуждение исходный текст
Ответ на query optimiser changes 6.5->7.0  ("Simon Hardingham" <simon@netxtra.net>)
Ответы Re: query optimiser changes 6.5->7.0
Список pgsql-general
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

OK this may seem like a stupid question, but isn't index scan always
better except for the pathalogical simple case where the work to be done
is trivial anyway?

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

Предыдущее
От: efinley@efinley.com (Elliot Finley)
Дата:
Сообщение: Re: btree index and max()
Следующее
От: Thomas Good
Дата:
Сообщение: Re: Perl interfaces?