Thread: Problem with btree index on 7.1.3

Problem with btree index on 7.1.3

From
Denis Perchine
Date:
Hello,

on 7.1.3 I get:
ERROR:  btree: index item size 3028 exceeds maximum 2713

it seems like known problem, and I have a feeling that it is fixed in 7.2 RC1,
but does anywhere a patch available for 7.1.3?

--
Denis

Re: Problem with btree index on 7.1.3

From
Mike Mascari
Date:
Denis Perchine wrote:
>
> Hello,
>
> on 7.1.3 I get:
> ERROR:  btree: index item size 3028 exceeds maximum 2713
>
> it seems like known problem, and I have a feeling that it is fixed in 7.2 RC1,
> but does anywhere a patch available for 7.1.3?

I believe the tuple toaster allows for (essentially) unlimited data
size. But I believe index sizes are still limited to around 2K. I could
be wrong, but I don't remember anything to the contrary.

Hope that helps,

Mike Mascari
mascarm@mascari.com