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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: akp geek <akpgeek(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: index row requires 10040 bytes, maximum size is 8191
Date: 2010-11-13 01:57:58
Message-ID: 1289613478.4869.18.camel@jd-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ray 2010-11-13 02:39:12 Re: Help with Stack Builder
Previous Message Craig Ringer 2010-11-13 01:48:04 Re: index row requires 10040 bytes, maximum size is 8191