Re: BUG #8048: Text Search

luigisag(at)gmail(dot)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