Re: Have: Seq Scan - Want: Index Scan - what am I doing wrong?

Поиск
Список
Период
Сортировка
От Chris Ruprecht
Тема Re: Have: Seq Scan - Want: Index Scan - what am I doing wrong?
Дата
Msg-id 1F0232A3-5C27-4462-9373-5323568CF65B@cdrbill.com
обсуждение исходный текст
Ответ на Re: Have: Seq Scan - Want: Index Scan - what am I doing wrong?  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-performance
Thanks Bruce,

I have, and I even thought, I understood it :).

I just ran an explain analyze on another table - and ever since the query plan changed. It's now using the index as
expected.I guess, I have some more reading to do. 

On Oct 16, 2012, at 20:31 , Bruce Momjian <bruce@momjian.us> wrote:

>
> Have you read our FAQ on this matter?
>



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Have: Seq Scan - Want: Index Scan - what am I doing wrong?
Следующее
От: "Sam Wong"
Дата:
Сообщение: Re: LIKE op with B-Tree Index?