Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS
Дата
Msg-id 20230214002957.bfdg2we3ch6v7mqo@awork3.anarazel.de
обсуждение исходный текст
Ответ на Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS  (Andrey Borodin <amborodin86@gmail.com>)
Ответы Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS  (Andrey Borodin <amborodin86@gmail.com>)
Список pgsql-hackers
Hi,

On 2023-02-13 16:23:30 -0800, Andrey Borodin wrote:
> But there are some caveats:
> 1. Some more increments on hot paths. We have to add this tiny toll to
> every single buffer hit, but it will be seldom of any use.

Additionally, I bet it slows down EXPLAIN (ANALYZE, BUFFERS) noticeably. It's
already quite expensive...


> All in all I do not have an opinion if this feature is a good tradeoff.
> What do you think? Does the feature look useful? Do we want a more
> polished implementation?

Unless the above issues could be avoided, I don't think so.

Greetings,

Andres Freund



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Add the ability to limit the amount of memory that can be allocated to backends.
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Make EXPLAIN generate a generic plan for a parameterized query