Re: The type int8 and the use of indexes

Поиск
Список
Период
Сортировка
От Igor V. Rafienko
Тема Re: The type int8 and the use of indexes
Дата
Msg-id Pine.SOL.4.21.0101261621550.16405-100000@andvarefoss.ifi.uio.no
обсуждение исходный текст
Ответ на Re: The type int8 and the use of indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
on Jan 26, 2001, 10:20, Tom Lane std::cout'ed:


| It won't use an index unless the optimizer knows that the number of
| rows to be selected is small, which for a one-sided "<" query would
| depend on where the endpoints of the data range are.  Had you done
| a VACUUM ANALYZE recently?


Yes, I believe I did run vacuum analyze just before the test.





ivr
--
"You have an internet connection on your calculator."
"You can type 70 words per minute -- on a TI-82."
"You've gotten electronic copies of text books in TI-82 format."
                           -- Technology in IB


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: The type int8 and the use of indexes
Следующее
От: James Thompson
Дата:
Сообщение: GNUe Forms 0.0.5 Released