Jesper Krogh <jesper@xxxxxxxx> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
