Postgres Pro
Downloads
Home   >   mailing lists

Re: Have: Seq Scan - Want: Index Scan - what am I doing wrong? - Mailing list pgsql-performance

From Chris Ruprecht
Subject Re: Have: Seq Scan - Want: Index Scan - what am I doing wrong?
Date
Msg-id 1F0232A3-5C27-4462-9373-5323568CF65B@cdrbill.com
Whole thread Raw
In response to Re: Have: Seq Scan - Want: Index Scan - what am I doing wrong?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Have: Seq Scan - Want: Index Scan - what am I doing wrong?
Next
From: "Sam Wong"
Date:
Subject: Re: LIKE op with B-Tree Index?