Postgres Pro
Downloads
Home   >   mailing lists

Re: indexing large "text" attributes ... ERROR: maximum size is 8191 - Mailing list pgsql-general

From Tom Lane
Subject Re: indexing large "text" attributes ... ERROR: maximum size is 8191
Date
Msg-id 8665.1186366638@sss.pgh.pa.us
Whole thread Raw
In response to indexing large "text" attributes ... ERROR: maximum size is 8191  (Benjamin Arai <me@benjaminarai.com>)
Responses Re: indexing large "text" attributes ... ERROR: maximum size is 8191  (Benjamin Arai <me@benjaminarai.com>)
List pgsql-general
Tree view 
Benjamin Arai <me@benjaminarai.com> writes:
> I am actually creating a GIN index on another field but I need to
> index the original "text" field to perform exact phrase matches.

Why do you think an extra index will be useful for that?  Especially
a btree index?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG for DataWarehouse type Queries
Next
From: Benjamin Arai
Date:
Subject: Re: indexing large "text" attributes ... ERROR: maximum size is 8191