"luigi...@gmail.com" <luigi...@gmail.com> wrote:
> CREATE TABLE "User_Full_Text_Search_2" (
> "Email" varchar(50),
> "UserId" varchar(50),
> "Full_Text_Search" varchar(4096),
> "tsv" varchar(4096)
> )
> WITH (OIDS=FALSE)
> ;
> CREATE INDEX IX_FullText_2 ON "User_Full_Text_Search_2"
> USING gin("tsv");
> I don't understand why a materialized column is more slow than a
> calculeted one...
Try materializing it as a tsvector instead of a varchar.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
