Re: [PATCH] pg_stat_statements dealloc field ignores manual deallocation

Поиск
Список
Период
Сортировка
От Andrei Zubkov
Тема Re: [PATCH] pg_stat_statements dealloc field ignores manual deallocation
Дата
Msg-id e0904bf7a92beeefdd17a773212514bb84e91bed.camel@moonset.ru
обсуждение исходный текст
Ответ на Re: [PATCH] pg_stat_statements dealloc field ignores manual deallocation  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-hackers
On Fri, 2021-03-19 at 22:15 +0800, Julien Rouhaud wrote:
> I disagree.  The point of that field is to help users configuring
> pg_stat_statements.max, as evictions have a huge overhead in many
> workloads.
> 
> If users remove entries for some reasons, we don't have to give the
> impression
> that pg_stat_statements.max is too low and that it should be
> increased,
> especially since it requires a restart.
> 
Ok.
But when we are collecting aggregated statistics on pg_stat_statememts
periodically it would be great to know about every deallocation
happened. Maybe we need to add another counter for manual deallocations
tracking?




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

Предыдущее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: Built-in connection pooler
Следующее
От: Andrei Zubkov
Дата:
Сообщение: [PATCH] Tracking statements entry timestamp in pg_stat_statements