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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: akp geek <akpgeek(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: index row requires 10040 bytes, maximum size is 8191
Date: 2010-11-12 20:52:26
Message-ID: 1289595146.4869.13.camel@jd-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2010-11-12 21:03:28 Re: index row requires 10040 bytes, maximum size is 8191
Previous Message Matthias Müller 2010-11-12 20:49:57 Re: Seeking advice on database replication.