Size limit on GiST nodes not documented

Поиск
Список
Период
Сортировка
От Morten Hustveit
Тема Size limit on GiST nodes not documented
Дата
Msg-id CAL3abtUPLt4o2oL8z2w4tuqj8qZ1QDcXsm43upUE-Yo=Cam9sQ@mail.gmail.com
обсуждение исходный текст
Список pgsql-docs
In GiST indexes, storing nodes larger than an index page is apparently
not allowed.  This prohibits, for example, storing 600 entry float8
arrays in the index.  For SP-GiST in PostgreSQL 9.2, it was decided
that this should be documented:

  "Individual leaf tuples and inner tuples must fit on a single index
page (8KB by default)."[1]

... but for GiST indexes, this is never mentioned explicitly.  The
result was that I wasted many hours developing a GiST index before
noticing it could not be used with my data.

1. http://www.postgresql.org/docs/9.2/static/spgist-implementation.html#SPGIST-LIMITS


В списке pgsql-docs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Wrong function name in the docs
Следующее
От: Peter Eisentraut
Дата:
Сообщение: pattern matching indexing