[Answered ]-Django-fts: How to create indexes for psql

You need:

CREATE INDEX "store_product_index" ON "store_product" USING gin(to_tsvector('english', "name"));

(assuming you want the index on english). See section 12.2.2 in the documentation at http://www.postgresql.org/docs/9.0/static/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX