Re: Metadata and record block access stats for indexes

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема Re: Metadata and record block access stats for indexes
Дата
Msg-id CAJ7c6TPhxerMTwAQ4dETQpb68QRb5tHwK9dM3MFZpK2E3y93Bg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Metadata and record block access stats for indexes  (Mircea Cadariu <cadariu.mircea@gmail.com>)
Список pgsql-hackers
Hi Mircea,

> Rebased and dusted off this patch.

Thanks for the patch. Here are my two cents.

IMO it would be helpful if you could come up with a few more practical
use cases. This change is going to affect pretty much everyone. If
only a few users will benefit from it once in several years, the value
of the patch is arguably low. As an example, can you think of how the
new counters can be used for debugging, checking index integrity,
writing new access methods or perhaps writing property-based tests?
Just several examples that came to my mind first.

Also I'm a bit concerned about the performance impact. It's probably
next to nothing, but if you could measure it on a relatively large
amount of data that would be great. Note that it's not uncommon to
have dozens of different indexes for a single table.

-- 
Best regards,
Aleksander Alekseev



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