Re: int4 in a GiST index - Mailing list pgsql-performance

From George Essig
Subject Re: int4 in a GiST index
Date
Msg-id 20041111025028.9044.qmail@web53706.mail.yahoo.com
Whole thread Raw
In response to int4 in a GiST index  (Mike Rylander <mrylander@gmail.com>)
Responses Re: int4 in a GiST index
List pgsql-performance
Mike Rylander wrote:

> I want to create a multi-column index across the tsvector and classification
> columns as that should help with selectivity.  But because there is no
> GiST opclass for INT4 the index creation complains thusly:

Install contrib/btree_gist along with contrib/tsearch2 to create a multicolumn index on the in4
and the tsvector columns.  See the following for an example:

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/oscon_tsearch2/multi_column_index.html

George Essig

pgsql-performance by date:

Previous
From: Mike Rylander
Date:
Subject: int4 in a GiST index
Next
From: Mike Rylander
Date:
Subject: Re: int4 in a GiST index