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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index not used for simple query, and yes I ran vacuum analyze
Дата
Msg-id 1589.1001527708@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Index not used for simple query, and yes I ran vacuum analyze  (Matthew Braithwaite <mab-lists@braithwaite.net>)
Список 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 по дате отправления:

Предыдущее
От: "Hawke Robinson"
Дата:
Сообщение: Re: createlang pltcl mydb fails...
Следующее
От: Andrew Spencer
Дата:
Сообщение: Default Values and Pl/Pgsql Function Calls