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

Matthew Braithwaite <mab-lists(at)braithwaite(dot)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