Denis Papathanasiou <denis.papathanasiou@xxxxxxxxx> writes: > So is it the case that, as in the documented example, I need to add a > column of type ts_vector to the table for the index to be most effective? You can do it either way, depending on what you want the queries to look like. One advantage of materializing the tsvector entries in the table is that the to_tsvector() work doesn't have to be done over again if the planner decides not to use that index for some reason (for instance, it thinks the other index is more effective for the particular query). regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
