Re: Add min and max execute statement time in pg_stat_statement

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Add min and max execute statement time in pg_stat_statement
Дата
Msg-id CAMkU=1xUnoddQHzQq9_b1UMWHbemVfRJX72f-0ezsv801ke6LQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add min and max execute statement time in pg_stat_statement  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Add min and max execute statement time in pg_stat_statement
Список pgsql-hackers
On Mon, Oct 21, 2013 at 4:29 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Andrew Dunstan <andrew@dunslane.net> writes:
> This is why I suggested the standard deviation, and why I find it would
> be more useful than just min and max. A couple of outliers will set the
> min and max to possibly extreme values but hardly perturb the standard
> deviation over a large number of observations.

Hm.  It's been a long time since college statistics, but doesn't the
entire concept of standard deviation depend on the assumption that the
underlying distribution is more-or-less normal (Gaussian)?  


It is easy to misinterpret the standard deviation if the distribution is not gaussian, but that is also true of the average.  The standard deviation (or the variance) is commonly used with non-gaussian distributions, either because it is the most efficient estimator for those particular distributions, or just because it is so commonly available.

Cheers,

Jeff

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: logical changeset generation v6.2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Reasons not to like asprintf