CG <[EMAIL PROTECTED]> writes:
> INFO: index "search_vector_idx" now contains 1344672 row versions in 47725
> pages
> INFO: "letter_search": found 9 removable, 1344661 nonremovable row versions
> in 33984 pages
Yikes ... the index is bigger than the table! Seems like you've not
been vacuuming enough, or else gist has got a major bloat problem.
If you REINDEX, does the index get materially smaller?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
