Обсуждение: Gin Implementation Page

Поиск
Список
Период
Сортировка

Gin Implementation Page

От
PG Doc comments form
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/gin-implementation.html
Description:

In the part 'when the list is small enough to fit into a single index
"tuple" along with the key value' should the word "tuple" be replaced by the
word "page"?

Re: Gin Implementation Page

От
Pavel Borisov
Дата:
If I'm not mistaken GIN will replace posting list to posting tree (and so shift it to another page) when on a current page there is not enough space. But this does not necessarily mean that page is not enough to accommodate current tuple(1). This rather means space left on a page is not necessary due to occupation by neighbouring tuples. (2)

If we just replace tuple -> page we'll get meaning (1) which is not precisely so.
I think existing description is accurate and doesn't need change basically.

Thanks for your question anyway!

--
Best regards,
Pavel Borisov

Postgres Professional: http://postgrespro.com