От: 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