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.
>> column is just character varying with no limit. I am getting the
>> error " index row requires 10040 bytes, maximum size is 8191"
>> What can I do the postgres.conf to handle this error? Appreciate your
> You can't. You could create a index on "part" of the data or use full
In some cases, depending on needs, indexing on the md5 hash of such data
can be useful.
In response to
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|