Re: Sequential scan being used despite indexes

От: Michael Fuhr
Тема: Re: Sequential scan being used despite indexes
Дата: ,
Msg-id: 20060201035803.GA6324@winnie.fuhr.org
(см: обсуждение, исходный текст)
Ответ на: Re: Sequential scan being used despite indexes  ("Joshua D. Drake")
Ответы: Re: Sequential scan being used despite indexes  (James Russell)
Список: pgsql-performance

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

Sequential scan being used despite indexes  (James Russell, )
 Re: Sequential scan being used despite indexes  ("Joshua D. Drake", )
  Re: Sequential scan being used despite indexes  (Michael Fuhr, )
   Re: Sequential scan being used despite indexes  (James Russell, )
    Re: Sequential scan being used despite indexes  (Christopher Kings-Lynne, )
    Re: Sequential scan being used despite indexes  (Michael Fuhr, )

On Tue, Jan 31, 2006 at 07:29:51PM -0800, Joshua D. Drake wrote:
> > Any ideas?
>
> What does explain analyze say?

Also, have the tables been vacuumed and analyzed?

--
Michael Fuhr


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

От: Richard Huxton
Дата:
Сообщение: Re: partitioning and locking problems
От: "FERREIRA, William (VALTECH)"
Дата:
Сообщение: execution plan : Oracle vs PostgreSQL