From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Seamus Abshere <seamus(at)abshere(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Optimizing CartoDB's JenksBins function |
Date: | 2014-03-18 17:19:24 |
Message-ID: | 5328801C.9060205@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 03/18/2014 09:42 AM, Seamus Abshere wrote:
> Our friends from CartoDB [1] provide a beautiful Jenks Natural
> Breaks function for Postgres [2]. It is quite computationally
> intensive.
>
> Even if you don't know what Jenks is, do you see any
> optimizations?
Not exactly what you asked, but you might try PL/R with the R
"classInt" package:
http://cran.at.r-project.org/web/packages/classInt/classInt.pdf
HTH,
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQIcBAEBAgAGBQJTKIAcAAoJEDfy90M199hlTcIP/0jK/8yuAN140a4oj54H4bOr
mJwf1XAj0/CefwdgCkaSioiiwSOUGTuJyz+VH05GhKeuWchKiQzuD+w5/ijbjOFj
qnxupIoULxBfk/ZA/8bh6/54IGDIlA1F8lFH9lHntPCLGgNnZkwYGsPMGntXUf2/
WfesFAY8D185rnlEVWbC3ZUgeEXj1kxl6xjAJEXlGBoESfGWTKUI04tfg3+wTpHp
A2F2Ck579XuxA5WK62fk0+d+B+ua/tixl2xCuRotQvtSQ6LVPQOlo1mBGuVxYtou
KrBdyv7rxQzWOxgNePuMBqnMsSowFMP9XC7Lzdlg1NsHQL9o1yLT1bdIrT5lX5OQ
DErvAHwh87kfcyFOYTl6uwS0I89gOuaTimYkghlX7dCPWnEu0KKDaLJnVVkcNfi8
Xpyj42AodsfKb7F0elPCYqgBhv+pRwXaPP3ig9SYMgU/h82UFdk/RexqWYK5FwAU
XwoeY/NioKahaQYpMXEnWmnvvueuuz+s8KCbNj7avXPEJE4RxuNVLIYShrN64Ydx
bW/1/Hpv98Gn71ksSjrVlru1xaxArQhiAImuepWp76LvpvW1rtRUy4+fDDIek+nF
TeHiQrzgkdywSKTJCgqxTjIO/PkWV8JIXghc/m0z6qud+8YPa6nbWnIq0XjSjOIQ
jQ4u2w6r/7GOl93tT3yY
=zPkM
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Richter | 2014-03-18 19:22:26 | Add column name to error message? |
Previous Message | Kevin Goess | 2014-03-18 17:07:06 | Re: pgpgout/s without swapping--what does it mean? |