Re: Index not used for simple query, and yes I ran vacuum analyze - Mailing list pgsql-novice

From Tom Lane
Subject Re: Index not used for simple query, and yes I ran vacuum analyze
Date
Msg-id 1589.1001527708@sss.pgh.pa.us
Whole thread Raw
In response to Index not used for simple query, and yes I ran vacuum analyze  (Matthew Braithwaite <mab-lists@braithwaite.net>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: "Hawke Robinson"
Date:
Subject: Re: createlang pltcl mydb fails...
Next
From: Andrew Spencer
Date:
Subject: Default Values and Pl/Pgsql Function Calls