Jesper Krogh <[email protected]> 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
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance