indexing large "text" attributes ... ERROR: maximum size is 8191

From: Benjamin Arai <me(at)benjaminarai(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: indexing large "text" attributes ... ERROR: maximum size is 8191
Date: 2007-08-06 02:03:51
Message-ID: 6C26ECBB-56BD-4580-AECA-5F57A75DF441@benjaminarai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I get the following error when tying to index a large text field:

dev=# CREATE INDEX idx_fulltext_articel_block ON fulltext_article
(article_block);
ERROR: index row requires 8724 bytes, maximum size is 8191

I am actually creating a GIN index on another field but I need to
index the original "text" field to perform exact phrase matches.
Does anybody know how to fix this or alternatively perform exact
phrase matches on a GIN index?

Thanks in advance!

Benjamin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-06 02:10:12 Re: PG for DataWarehouse type Queries
Previous Message Perry Smith 2007-08-06 01:53:46 Re: pg_dump of only the structure from a client such as ruby