Jesper Krogh <jesper(at)krogh(dot)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
In response to
pgsql-performance by date
|Next:||From: Robert Haas||Date: 2009-10-18 20:00:25|
|Subject: Re: Calculation of unused columns|
|Previous:||From: Jesper Krogh||Date: 2009-10-18 18:55:49|
|Subject: Re: Full text search - query plan? PG 8.4.1|