Re: Performance ts_vector fulltext search

[Tom Lane]

Luigi Saggese <luig...@gmail.com> writes:
> I've configured 2 table like this
> ...
> CREATE INDEX "ix_fulltext_usp_what" ON "public"."User_Statement_Pivot"
> ("to_tsvector('italian'::regconfig, ""What""::text)",
> "to_tsvector('italian'::regconfig, ""What""::text)");

When I try that I get

ERROR: column "to_tsvector('italian'::regconfig, "What"::text)" does not exist

as indeed I should, because you seem to be confused about SQL quoting
rules --- that whole expression is being taken as a name. However, the
bigger problem here is that you're creating btree indexes, which are not
useful for full text search. They need to be gin or gist indexes. See
examples at

http://www.postgresql.org/docs/9.2/static/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX

regards, tom lane


--
Sent via pgsql-performance mailing list (pgsql-pe...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance