Re: Add min and max execute statement time in pg_stat_statement

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Add min and max execute statement time in pg_stat_statement
Дата
Msg-id 54E3E91C.4020105@gmx.net
обсуждение исходный текст
Ответ на Re: Add min and max execute statement time in pg_stat_statement  (David G Johnston <david.g.johnston@gmail.com>)
Ответы Re: Add min and max execute statement time in pg_stat_statement
Re: Add min and max execute statement time in pg_stat_statement
Список pgsql-hackers
On 1/20/15 6:32 PM, David G Johnston wrote:
> In fact, as far as
> the database knows, the values provided to this function do represent an
> entire population and such a correction would be unnecessary.  I guess it
> boils down to whether "future" queries are considered part of the population
> or whether the population changes upon each query being run and thus we are
> calculating the ever-changing population variance.

I think we should be calculating the population variance.  We are
clearly taking the population to be all past queries (from the last
reset point).  Otherwise calculating min and max wouldn't make sense.




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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Strange assertion using VACOPT_FREEZE in vacuum.c
Следующее
От: Petr Jelinek
Дата:
Сообщение: Re: mogrify and indent features for jsonb