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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthew Braithwaite <mab-lists(at)braithwaite(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org, Matthew Braithwaite <matt(at)braithwaite(dot)net>
Subject: Re: Index not used for simple query, and yes I ran vacuum analyze
Date: 2001-09-26 18:08:28
Message-ID: 1589.1001527708@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew Spencer 2001-09-27 14:45:49 Default Values and Pl/Pgsql Function Calls
Previous Message Hawke Robinson 2001-09-26 16:48:59 Re: createlang pltcl mydb fails...