Re: Full text search - query plan? PG 8.4.1 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Full text search - query plan? PG 8.4.1
Date
Msg-id 9618.1255895298@sss.pgh.pa.us
Whole thread Raw
In response to Re: Full text search - query plan? PG 8.4.1  (Jesper Krogh <jesper@krogh.cc>)
Responses Re: Full text search - query plan? PG 8.4.1
List 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 by date:

Previous
From: Jesper Krogh
Date:
Subject: Re: Full text search - query plan? PG 8.4.1
Next
From: Robert Haas
Date:
Subject: Re: Calculation of unused columns