Re: BUG #8048: Text Search - Mailing list pgsql-bugs

luigisag@gmail.com writes:
>         CREATE TABLE "User_Full_Text_Search_2" (
>         "Email" varchar(50),
>         "UserId" varchar(50),
>         "Full_Text_Search" varchar(4096),
>         "tsv" varchar(4096)
>         )
>         WITH (OIDS=FALSE)
>         ;

You declared tsv as a plain varchar column, not a tsvector, so text
searches on it aren't optimized.  I'm surprised the system even let
you build a GIN index on it --- maybe you have btree_gin installed?
Anyway that index isn't useful for answering a full-text-search
query, as you'll see if you compare EXPLAIN results.

            regards, tom lane