Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aAo6p-0005Kt-F1 for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Dec 2015 00:13:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aAo6o-0002w6-PS for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Dec 2015 00:13:50 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aAo6n-0002vz-OD for pgsql-hackers@postgresql.org; Mon, 21 Dec 2015 00:13:50 +0000 Received: from mail-by2on0054.outbound.protection.outlook.com ([207.46.100.54] helo=na01-by2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aAo6k-00087H-N1 for pgsql-hackers@postgresql.org; Mon, 21 Dec 2015 00:13:48 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=wypG3Awnf91K0URAgyhQ9CQEb+K2FJrzBvmDKZtjZic=; b=ledVA22S202KrxO9Z8yA2UV6uT2bO6bqPz3S79VBtnI8Ed03ZGc73Iq3Sf6i23MOtZAqglvyBzJXUMfwYlPPBGNVMT+/xbOSxrvTs/mJQKf06L9oofrkCcl9ufzbmeg1QRJQo9/fcZnrEONhV/og2/OsdIMMEvE+D50IQMPhJGg= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.local (70.113.16.71) by CY1PR11MB0681.namprd11.prod.outlook.com (10.163.236.19) with Microsoft SMTP Server (TLS) id 15.1.361.13; Mon, 21 Dec 2015 00:13:43 +0000 Subject: Re: Weighted Stats To: David Fetter , PG Hackers References: <20151102234644.GA31118@fetter.org> From: Jim Nasby Message-ID: <5677442D.9070204@BlueTreble.com> Date: Sun, 20 Dec 2015 18:13:33 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:38.0) Gecko/20100101 Thunderbird/38.4.0 MIME-Version: 1.0 In-Reply-To: <20151102234644.GA31118@fetter.org> Content-Type: text/plain; charset="windows-1252"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [70.113.16.71] X-ClientProxiedBy: BLUPR05CA0058.namprd05.prod.outlook.com (10.141.20.28) To CY1PR11MB0681.namprd11.prod.outlook.com (25.163.236.19) X-Microsoft-Exchange-Diagnostics: 1; CY1PR11MB0681; 2:lwwFCyey1VbUPBNy7WXcfCalwxExwdKYClJEx8UzJcbHQDUq6Oh+1a014ysLNomNfXQQr3YRsehKLcEgBJzoVVyJR5k/e6ApGIjI7utz4efDhilVzddQwt3idz5RKcOi3aRk7xWteoxktJlyatb6fA==; 3:Ch2Gssh1cSOjkUey5d057Dw9CAzk9djlKSg+Sd0KZRggLaGiGs7XAIx2PnyA6hciXHBMHepNyVv1cZGFHCHsxuL/Dmx2/BkoPWEeIQNWDgZ/7yzMhg8rvdqmcLQ+L3Jl; 25:Fs+B6kxCXxjO6vzP3tcGKSk8m3RUmDaspl7b8AEBJe707KRs4yQT3CKCtIq1aIi1+BwqOx81PpsFAvWEde85VUqpco2aEJA11Y7HOHwaL7qHgVhm2OtadkinLoFHp05UEBuxy2RRsLNcCKQ+9J3bfoHjd+cTb7tFnzhPcTxPFSDTWS89knmBGyfo3m8TP737oeWhzcgDYeGsx/V2gAQfPXjWYfGx7GGbRkVMOfiog+KqyvsTdM+zqk01W3gnBYIUa9WNayyilotLX652YkDsfw==; 20:/gO6ilw0fpbnR02LtOIKect+x4p+w+b5c9jnYNsQAL2DA09DmrCcEQim3U+BcznOTdO7YUwk9DLeWgQ2O3RM+ezBaSLxEvk4AVJiWtelwXU4QIKUql/aj0BkWs4wsCzM65u9f5evg0q52/EWB7hIMAPXZ3xP0i57GcSE/y4298U= X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:CY1PR11MB0681; X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(601004)(2401047)(520078)(5005006)(8121501046)(3002001)(10201501046); SRVR:CY1PR11MB0681; BCL:0; PCL:0; RULEID:; SRVR:CY1PR11MB0681; X-Microsoft-Exchange-Diagnostics: 1; CY1PR11MB0681; 4:bHf9bIFBWnPea+4N1ea7V5BwKH2pcblmUwA1okqiW6ORY3V1WyYKmA3rTOl3kgvTzoLWL0JVVeeX+D+jCe/m/nNd+wS8JCBhAwUIMCUtuVBqp3zYaGzQolI9j3ZGD1RptprZkaqKh6ULMzK6d3Jc5u9heZTNMhg2OaJbk/cTvCx1pJ+cHWtOk8cybwJPainlianJuaRHz2GSprEccEJXo6Wd6Bk4gXY7LRfhsa9BTtEIjcVqMgbsuTh4rPFsYud8bUGjF+atTBilDxTwVrYLYIvt9qRhvCwgtByeJ4bcor1WY7MhJOG7SdN+l4r9stRdlYMGv/Ih7X8wXmJQ3oI2+v9zNGfUDkqUViwcE3KZFj+eHIq1/7DcGcx/Z5cIVocL X-Forefront-PRVS: 079756C6B9 X-Forefront-Antispam-Report: SFV:NSPM; SFS:(10009020)(6009001)(24454002)(199003)(479174004)(377454003)(189002)(33656002)(50466002)(50986999)(87266999)(65816999)(40100003)(15975445007)(76176999)(5004730100002)(54356999)(23746002)(122386002)(80316001)(83506001)(4001350100001)(77096005)(42186005)(97736004)(81156007)(36756003)(105586002)(47776003)(87976001)(92566002)(65956001)(19580395003)(2950100001)(101416001)(65806001)(106356001)(99136001)(66066001)(64126003)(5001770100001)(6116002)(5008740100001)(3846002)(189998001)(1096002)(230700001)(586003)(107886002)(5001960100002)(86362001)(59896002)(85282002)(336755003)(18886065003); DIR:OUT; SFP:1101; SCL:1; SRVR:CY1PR11MB0681; H:decina.local; FPR:; SPF:None; PTR:InfoNoRecords; A:1; MX:1; LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?Windows-1252?Q?1; CY1PR11MB0681; 23:Ab7S7AgnM0WQOJSiZoHXDUGX6glsuzuWFKgAW?= =?Windows-1252?Q?frBPNNGleOJQ9JoEc1Ae7MyqBHAZRr44hC1/YaTKettvX1QAhTLmp4jz?= =?Windows-1252?Q?bt3mvsYze32tMHTFFBgIChsoCTjlcS3fRsgPJvm5H1Yiu9iMVe1EIwcA?= =?Windows-1252?Q?pWKXv9/wh4VEJElyfLqFjYs+gc0kzNpOkdmm8WMeAm1AkrtQ7mojZSyW?= =?Windows-1252?Q?hRD3RH3hU+pO9QPt1s+IEIIf1qSrRO3rJO6psAvMYalVC1512jqcxeZ9?= =?Windows-1252?Q?ViSLJ1ICMWsJ5RkIDIRQ7+T6eURuvTZYFjtKrHb+6KsZsEz/gJCzu0HV?= =?Windows-1252?Q?uq2VJVtNj9hKMtWiJhuk8fc9wv2udqFKQbetGCvew804WdFVJtVOHqdP?= =?Windows-1252?Q?KOglOUBbbbnL5nv86wco3N/CvGm+9yFJmp74LuA3uaZsU08mBWH97xkD?= =?Windows-1252?Q?incCQI3Z/MP1hqyUnxxRAlh+VtPBW8uTSSzdBJ/wUuwL4fPymttlUwr9?= =?Windows-1252?Q?KB7t5QRF0V7LbyIkg+eKoAu/a5xwI2AnL00JMyaZ5QGzzAAEKvp6TSgg?= =?Windows-1252?Q?0vHzfmFVdmJhJYOuEASZbDjtt4O5hdp7Xc0o+60u+My9Anh4cwFEvpjV?= =?Windows-1252?Q?aZnCBTrRWfO2lAqfTB4NEIJbCR45MXgCuX7Sp0U3sVVk4gg7/xc+cCJi?= =?Windows-1252?Q?fGyIxmWSJ2BB9pokiVYBkOXICEXme9YWXkXOSVfWnBY2/2rsOsDySYnd?= =?Windows-1252?Q?79LYHqBKWMfy4PiOEmYVEFDZ7/1soKzD5wSLuqQC5w5yrBr4LWFLblbr?= =?Windows-1252?Q?rpHMcDSXh20v2ToprF17rp55sexzjJ1A8G2Xpl+K1KTXbA8/y77Gp5wj?= =?Windows-1252?Q?uN0HQO5pIXM1OCF6489JcHeuo0kgHQCW175uap+Brr6Xz7WtJkutKHuY?= =?Windows-1252?Q?Dom0XJXxpLLV5x4kNBjrzCvIKWW1JEegWRXOJ+JvRNyKm5fIoY2KstyJ?= =?Windows-1252?Q?F0uSyxI5B5GEYiz82sOiVtHDlnF0ycmqWQTvXYl6By4FkD45Qfh2Hg+k?= =?Windows-1252?Q?Il3V9z5iw66gmgH9cldU7Snn+Yh8In0TV3E1hW47s/ehrLFn+72+bQG4?= =?Windows-1252?Q?3+ATI7PGTcA4Eryt9hL6QyOsa9SORMghM2q6Bf3ND0NUbYn5W8hCdcb5?= =?Windows-1252?Q?qww07ERR38VGQjowz40ErhqUJYUnYdZt0dLQQsiIr/vfrcYwcNKdm+16?= =?Windows-1252?Q?QR/mruEtQTC3oPbZmLI009xRuamByQdALowKReDHmm2udts+tFZ5vvHX?= =?Windows-1252?Q?y6KygWCPDqYg047xFZP6HNjyU79OmvQxf59lcxw787C0HnYOVsUCHlLu?= =?Windows-1252?Q?NEJZ43F0ze48fyBT4N0bEoh/q4IQ8GGfOxLYSokjG6h+sItEO+RvNHTe?= =?Windows-1252?Q?Z9lnIIlrR8TTCHhajDzETfQZEiCNsHWBVLwpbZzSmR3l7WaIVMD4Me28?= =?Windows-1252?Q?LRGorxVWdoicxvMeU7GroEYET0n?= X-Microsoft-Exchange-Diagnostics: 1; CY1PR11MB0681; 5:dvS7Re0LPPfYz5lwR3ti6JqnZg8AGC6aeZzuvUW97qbp+ApQtC5t6fJgXdX07gNScN2DOxfTKQccOVXb0twBuKzSEtBHzMP/Ji8LikLjAYamw+xxET/WhWiE+5m5DNPqSCvA2AJX0vIbfLWZDreG5A==; 24:YWdCbcT1aESIY9oBbF7SLtqrG/0bXvebnTEBU/kAxSkuYHLsPo5EXb6JLKrEu6HQF5atBKhwIZwVTglJdhMnBsuIQFoAYmyFjSqg74+AeKQ= SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 21 Dec 2015 00:13:43.0629 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY1PR11MB0681 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 11/2/15 5:46 PM, David Fetter wrote: > I'd like to add weighted statistics to PostgreSQL Anything happen with this? If community isn't interested, ISTM it'd be good to put this in PGXN. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers