CG <cgg007@yahoo.com> 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