Re: Problem with btree index on 7.1.3 - Mailing list pgsql-general

From Mike Mascari
Subject Re: Problem with btree index on 7.1.3
Date
Msg-id 3C4FF802.AF213FC2@mascari.com
Whole thread Raw
In response to Problem with btree index on 7.1.3  (Denis Perchine <dyp@perchine.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: Auto Increase
Next
From: Marcelo Pereira
Date:
Subject: Re: Auto Increase