Skip site navigation (1) Skip section navigation (2)

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

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: jd(at)commandprompt(dot)com
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-12 21:03:28
Message-ID: 4CDDABA0.4080500@pinpointresearch.com (view raw or flat)
Thread:
Lists: pgsql-general
On 11/12/2010 12:52 PM, Joshua D. Drake wrote:
> 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
>
>    
In some cases, depending on needs, indexing on the md5 hash of such data 
can be useful.

Cheers,
Steve


In response to

pgsql-general by date

Next:From: Dann CorbitDate: 2010-11-12 21:10:41
Subject: Re: More then 1600 columns?
Previous:From: Joshua D. DrakeDate: 2010-11-12 20:52:26
Subject: Re: index row requires 10040 bytes, maximum size is 8191

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group