Index size limits

Поиск
Список
Период
Сортировка
От Mark Rae
Тема Index size limits
Дата
Msg-id 20020510092537.GB11713@purplebat.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Denis Gasparin
Дата:
Сообщение: Re: Psql 7.2.1 Regress tests failed on RedHat 7.3
Следующее
От: "Marin Dimitrov"
Дата:
Сообщение: Re: Subject: bool / vacuum full bug followup part 2