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

Поиск
Список
Период
Сортировка
От Benjamin Arai
Тема indexing large "text" attributes ... ERROR: maximum size is 8191
Дата
Msg-id 6C26ECBB-56BD-4580-AECA-5F57A75DF441@benjaminarai.com
обсуждение исходный текст
Ответы Re: indexing large "text" attributes ... ERROR: maximum size is 8191
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Perry Smith
Дата:
Сообщение: Re: pg_dump of only the structure from a client such as ruby
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PG for DataWarehouse type Queries