{"id":712,"date":"2012-07-30T09:19:17","date_gmt":"2012-03-01T17:02:46","guid":{"rendered":"http:\/\/blog.light42.com\/wordpress\/?p=712"},"modified":"2013-09-07T17:33:47","modified_gmt":"2013-09-08T00:33:47","slug":"plr-median","status":"publish","type":"post","link":"http:\/\/blog.light42.com\/wordpress\/?p=712","title":{"rendered":"plr median"},"content":{"rendered":"

\"pg_logo\"<\/p>\n


\n----------------------------------------- install ------------
\ncreate or replace function r_median(_float8) returns float as '
\n median(arg1)
\n' language 'plr';<\/p>\n

CREATE AGGREGATE median (
\n sfunc = plr_array_accum,
\n basetype = float8,
\n stype = _float8,
\n finalfunc = r_median
\n);
\n<\/code><\/p>\n


\n----------------------------------------- test ---------------
\nselect max(a.res),avg(a.res),median(a.res),min(a.res)
\nfrom
\n ( select (st_area(wkb_geometry) - shape_area) as res
\n from landtypes_090911_marin_parcel_adjusted) a;<\/p>\n

thuban1 Time: 21255 ms
\nr900 Time: 13880 ms
\nps Time: 9337 ms
\nmacpro Time: 8856 ms
\ni7-960+ Time: 6980 ms
\n<\/code><\/p>\n

\nps-<\/em> add standard deviation sd<\/strong> too
\npps-<\/em> just noticed this post<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

—————————————– install ———— create or replace function r_median(_float8) returns float as ‘ median(arg1) ‘ language ‘plr’; CREATE AGGREGATE median ( sfunc = plr_array_accum, basetype = float8, stype = _float8, finalfunc = r_median ); —————————————– test ————— select max(a.res),avg(a.res),median(a.res),min(a.res) from ( select (st_area(wkb_geometry) – shape_area) as res from landtypes_090911_marin_parcel_adjusted) a; thuban1 Time: 21255 ms r900 Time: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/712"}],"collection":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=712"}],"version-history":[{"count":12,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/712\/revisions"}],"predecessor-version":[{"id":1305,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/712\/revisions\/1305"}],"wp:attachment":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=712"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}