От: Kevin Grittner
Тема: Re: Problems with FTS
Дата: ,
Msg-id: 4D0CA1890200002500038774@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Problems with FTS  (Rauan Maemirov)
Ответы: Re: Problems with FTS  (Rauan Maemirov)
Список: pgsql-performance

Скрыть дерево обсуждения

Problems with FTS  (Rauan Maemirov, )
 Re: Problems with FTS  ("Kevin Grittner", )
  Re: Problems with FTS  (Rauan Maemirov, )
   Re: Problems with FTS  (Robert Haas, )
    Re: Problems with FTS  (Rauan Maemirov, )
     Re: Problems with FTS  (Robert Haas, )
      Re: Problems with FTS  (Jesper Krogh, )

Rauan Maemirov  wrote:

> EXPLAIN SELECT [...]

Please show us the results of EXPLAIN ANALYZE SELECT ...

Also, please show us the table layout (including indexes), and
details about your hardware and PostgreSQL configuration.  See this
page for details:

http://wiki.postgresql.org/wiki/SlowQueryQuestions

> As you can see the query doesn't use index.

That means that either the optimizer thinks that the index isn't
usable for this query (due to type mismatch or some such) or that it
thinks a plan without the index costs less to run (i.e., it will
generally run faster).  You haven't told us enough to know whether
that is actually true, much less how to allow PostgreSQL to develop
more accurate costing estimates in your environment if it's currently
wrong about this.

-Kevin


В списке pgsql-performance по дате сообщения:

От: Royce Ausburn
Дата:
Сообщение: Re: Auto-clustering?
От: Royce Ausburn
Дата:
Сообщение: Re: Auto-clustering?