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

• Re: index row requires 10040 bytes, maximum size is 8191 at 2010-11-12 20:52:26 from Joshua D. Drake

pgsql-general by date

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