Re: Full text index not being used - Mailing list pgsql-general

> I tried to create an index including all of the fields I query on to
> see if that would work, but I get an error the the index row is too
> large:
>
> => create index master_index on source_listings(geo_lat, geo_lon,
> price, bedrooms, region, city, listing_type, to_tsvector('english',
> full_listing), post_time);
It's not a fulltext index - btree doesn't support @@ operation. Read
carefully: http://www.postgresql.org/docs/8.3/static/textsearch.html ,
and about full text indexes:
http://www.postgresql.org/docs/8.3/static/textsearch-tables.html ,
http://www.postgresql.org/docs/8.3/static/textsearch-indexes.html