Re: Full text search - query plan? PG 8.4.1

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Full text search - query plan? PG 8.4.1
Дата
Msg-id 9618.1255895298@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Full text search - query plan? PG 8.4.1  (Jesper Krogh <jesper@krogh.cc>)
Ответы Re: Full text search - query plan? PG 8.4.1  (Jesper Krogh <jesper@krogh.cc>)
Список pgsql-performance
Jesper Krogh <jesper@krogh.cc> writes:
> Tom Lane wrote:
>> ... There's something strange about your tsvector index.  Maybe
>> it's really huge because the documents are huge?

> huge is a relative term, but length(ts_vector(body)) is about 200 for
> each document. Is that huge?

It's bigger than the toy example I was trying, but not *that* much
bigger.  I think maybe your index is bloated.  Try dropping and
recreating it and see if the estimates change any.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jesper Krogh
Дата:
Сообщение: Re: Full text search - query plan? PG 8.4.1
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Calculation of unused columns