Re: int4 in a GiST index

From: George Essig <george_essig(at)yahoo(dot)com>
To: Mike Rylander <mrylander(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: int4 in a GiST index
Date: 2004-11-11 02:50:28
Message-ID: 20041111025028.9044.qmail@web53706.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mike Rylander 2004-11-11 05:53:09 Re: int4 in a GiST index
Previous Message Mike Rylander 2004-11-10 21:51:35 int4 in a GiST index