CG <cgg007@xxxxxxxxx> 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
