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