Re: Index not used for simple query, and yes I ran vacuum analyze

Matthew Braithwaite <mab-lists@braithwaite.net> writes:
> I RTFM but I'm still confused.  I have a table, headers
>> mab=> \d headers
>> Table "headers"
>> Attribute |  Type   |                        Modifier
>> -----------+---------+---------------------------------------------------------
>> header_id | integer | not null default nextval('headers_header_id_seq'::text)
>> part_id   | integer | not null
>> key       | text    |
>> value     | text    |
>> Index: headers_pkey

> I have indexed the table by part_id:

>> mab=> \d headers_ref_idx
>> Index "headers_ref_idx"
>> Attribute |  Type
>> -----------+---------
>> part_id   | integer
>> btree

Um, it sure looks like that index is not on that table.  Note that the
"\d headers" output shows only one index, named headers_pkey.

            regards, tom lane