Postgres Pro
Downloads
Home   >   mailing lists

Re: index row requires 10040 bytes, maximum size is 8191 - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: index row requires 10040 bytes, maximum size is 8191
Date
Msg-id 1289613478.4869.18.camel@jd-desktop
Whole thread Raw
In response to Re: index row requires 10040 bytes, maximum size is 8191  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: index row requires 10040 bytes, maximum size is 8191  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Craig Ringer
Date:
Subject: Re: index row requires 10040 bytes, maximum size is 8191
Next
From: ray
Date:
Subject: Re: Help with Stack Builder