Index size limits - Mailing list pgsql-general

From Mark Rae
Subject Index size limits
Date
Msg-id 20020510092537.GB11713@purplebat.com
Whole thread Raw
List pgsql-general
Hi,

Using 7.2.1 I just got this error message

ERROR:  btree: index item size 2824 exceeds maximum 2713

searching the mailing lists I came across this explaination by
Tom Lane

> The btree code assumes it can fit at least three keys per page, and if
> you have some keys > 1/3 page then sooner or later three of them will
> need to be stored on the same page.  6.5.2 didn't complain in advance,
> it just crashed hard when that situation came up.  7.0 prevents the
> problem by not letting you store an oversized key to begin with.
> (Hopefully all these tuple-size-related problems will go away in 7.1.)

Obviously, these problems have not gone away, and you can quite happily
create larger keys without any warning.

Will this be fixed in 7.3 or at least put the creation time check
in a 7.2.2 release if there is one?

    -Mark


pgsql-general by date:

Previous
From: Denis Gasparin
Date:
Subject: Re: Psql 7.2.1 Regress tests failed on RedHat 7.3
Next
From: "Marin Dimitrov"
Date:
Subject: Re: Subject: bool / vacuum full bug followup part 2