Re: index row requires 10040 bytes, maximum size is 8191

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: index row requires 10040 bytes, maximum size is 8191
Дата
Msg-id 5018.1289849777@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: index row requires 10040 bytes, maximum size is 8191  (akp geek <akpgeek@gmail.com>)
Список pgsql-general
akp geek <akpgeek@gmail.com> writes:
> What we do with the text that I have mentioned is, we have
> search functionality on the text. The user enters some keywords and then the
> application should be able to search for all the text that matches the key
> word.

Well, a btree index on the entire string is approximately useless for
that anyway.  Look into the text search functionality.

            regards, tom lane

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Backends "hanging" with strace showing selects?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Backends "hanging" with strace showing selects?