Re: timestamp indexing

Список
Период
Сортировка
От Jim C. Nasby
Тема Re: timestamp indexing
Дата
Msg-id 20050609180453.GQ44623@decibel.org
обсуждение исходный текст
Ответ на Re: timestamp indexing  (Tobias Brox)
Ответы Re: timestamp indexing  (Tobias Brox)
Список pgsql-performance
Дерево обсуждения
timestamp indexing  (Tobias Brox, )
 Re: timestamp indexing  (Michael Fuhr, )
  Re: timestamp indexing  (Tobias Brox, )
   Re: timestamp indexing  (Tom Lane, )
    Re: timestamp indexing  (Tobias Brox, )
     Re: timestamp indexing  (Tobias Brox, )
      Re: timestamp indexing  ("Jim C. Nasby", )
       Re: timestamp indexing  (Tobias Brox, )
What does

SET enable_seqscan = false;
EXPLAIN ANALYZE SELECT * FROM ...

get you? Is it faster?

BTW, I suspect this behavior is because the estimates for the cost of an
index scan don't give an appropriate weight to the correlation of the
index. The 'sort and index' thread on this list from a few months ago
has more info.
--
Jim C. Nasby, Database Consultant               
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

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

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: Help specifying new web server/database machine
Следующее
От: Junaili Lie
Дата:
Сообщение: Re: Help with rewriting query