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

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: index row requires 10040 bytes, maximum size is 8191
Дата
Msg-id 1289613478.4869.18.camel@jd-desktop
обсуждение исходный текст
Ответ на Re: index row requires 10040 bytes, maximum size is 8191  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: index row requires 10040 bytes, maximum size is 8191  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Sat, 2010-11-13 at 09:48 +0800, Craig Ringer wrote:

>
> Thoughts, folks? Does this matter in practice, since anything you'd want
> to index will in practice be small enough or a candidate for full-text
> indexing?
>

I have run into this problem maybe 3 times in my whole career, precisely
because if you are dealing with text that big, you move to full text
search.

JD

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt


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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: index row requires 10040 bytes, maximum size is 8191
Следующее
От: ray
Дата:
Сообщение: Re: Help with Stack Builder