On Mon, Mar 17, 2014 at 03:41:03PM -0700, Paul Norman wrote: > - I have a dataset of 100 million to 500 million points > across the US
[...] > Has anyone got any suggestions for how to efficiently render heatmaps > from datasets this large? I was thinking of two tables, one with the > raw data for high zooms and one pre-aggregated into space and time > bins (e.g. requests in a given box in a given time range) for use > in lower zooms. The aggregation operation would obviously be slow, but > I'd only have to do it once. Pre-aggregation would surely help, big problem being amount of records that need to be read from disk. You could also look at postgis raster as the aggregation type. --strk; () ASCII ribbon campaign -- Keep it simple ! /\ http://strk.keybit.net/rants/ascii_mails.txt _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
