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

From: Chris Ruprecht <chris(at)cdrbill(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Evgeny Shishkin <itparanoia(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Have: Seq Scan - Want: Index Scan - what am I doing wrong?
Date: 2012-10-17 00:43:00
Message-ID: 1F0232A3-5C27-4462-9373-5323568CF65B@cdrbill.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)us> wrote:

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Sam Wong 2012-10-17 01:01:09 Re: LIKE op with B-Tree Index?
Previous Message Bruce Momjian 2012-10-17 00:31:06 Re: Have: Seq Scan - Want: Index Scan - what am I doing wrong?