Re: Adding percentile metrics to pg_stat_statements module

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Adding percentile metrics to pg_stat_statements module
Дата
Msg-id 20191101141751.6ixckomofyhejqws@development
обсуждение исходный текст
Ответ на Re: Adding percentile metrics to pg_stat_statements module  (Igor Calabria <igor.calabria@gmail.com>)
Ответы Re: Adding percentile metrics to pg_stat_statements module  (Igor Calabria <igor.calabria@gmail.com>)
Список pgsql-hackers
On Fri, Nov 01, 2019 at 11:11:13AM -0300, Igor Calabria wrote:
>Yeah, I agree that there's no reason to store the digests themselves and I
>really liked the idea of it being optional.

That's not what I wrote. My point was that we *should* store the digests
themselves, otherwise we just introduce additional errors into the
estimates, because it discards the weights/frequencies.

>If it turns out that memory consumption on real workloads is small enough,
>it could eventually be turned on by default.
>

Maybe, but it's not just about memory consumption. CPU matters too.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services 



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

Предыдущее
От: Igor Calabria
Дата:
Сообщение: Re: Adding percentile metrics to pg_stat_statements module
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Remove configure --disable-float4-byval and --disable-float8-byval