Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group