[postgis-users] PostGIS heatmap generation

[Sandro Santilli]

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