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 1289595146.4869.13.camel@jd-desktop
Whole thread Raw
In response to index row requires 10040 bytes, maximum size is 8191  (akp geek <akpgeek@gmail.com>)
Responses Re: index row requires 10040 bytes, maximum size is 8191  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: index row requires 10040 bytes, maximum size is 8191  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Tree view 
On Fri, 2010-11-12 at 15:47 -0500, akp geek wrote:
> Hi all -
>
>             I am trying to create an index on character varying field.
> The
> column is just character varying with no limit. I am getting the
> following
> error " index row requires 10040 bytes, maximum size is 8191"
> What can I do the postgres.conf to handle this error? Appreciate your
> help

You can't. You could create a index on "part" of the data or use full
text.

JD

>
> Regards
--
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: akp geek
Date:
Subject: index row requires 10040 bytes, maximum size is 8191
Next
From: Steve Crawford
Date:
Subject: Re: index row requires 10040 bytes, maximum size is 8191