Re: Avoiding redundant fetches of btree index metapages

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Avoiding redundant fetches of btree index metapages
Дата
Msg-id 19169.1146070435@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Avoiding redundant fetches of btree index metapages  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Avoiding redundant fetches of btree index metapages  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> Hmmm.... I'm slightly worried that frequently-churning small tables will
> be made even slower by this. What do you think?

How so?

> So we would be able to cache other items also?

Only to the extent that you can guarantee a stale cache entry isn't a
problem.  We've already done the analysis involved for the existing
metapage entries, but anything else would require more thought.  (And
more cache flush events.)

> For that case we'd save N block accesses to locate the rightmost leaf
> page.

Surely you mean log(N).
        regards, tom lane


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

Предыдущее
От: Gevik Babakhani
Дата:
Сообщение: Regarding TODO item "%Add a separate TRUNCATE permission"
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Avoiding redundant fetches of btree index metapages