Weighted Stats

From: David Fetter <david(at)fetter(dot)org>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Weighted Stats
Date: 2015-11-02 23:46:44
Message-ID: 20151102234644.GA31118@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


I'd like to add weighted statistics to PostgreSQL. While the included
weighted_avg() is trivial to calculate using existing machinery, the
included weighted_stddev_*() functions are not.

I've only done the float8 versions, but if we decide to move forward,
I'd be delighted to add the rest of the numeric types and maybe others
as make sense.

What say?

David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Attachment Content-Type Size
weighted_stats_001.diff text/plain 17.7 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message YuanyuanLiu 2015-11-03 01:46:26 Re: Why not to use 'pg_ctl start -D ../data' to register posgtresql windows service
Previous Message Tom Lane 2015-11-02 23:36:20 Re: WIP: Rework access method interface