GIN Index on Postgres

Install postgresql-contrib package 
apt-get install postgresql-contrib-9.x
(replace x with current version in used)


Create extension pg_trgm
log in postgres with superuser role,
CREATE EXTENSION IF NOT EXISTS pg_trgm;


Create GIN index
CREATE INDEX tbdatatest_idx_date  on tbdatatest  USING GIN ( playerid gin_trgm_ops);