[postgis-devel] Windowing Functions for Clustering

[Paul Norman]

On 12/19/2015 12:36 PM, Daniel Baston wrote:
>
> Are there any caveats we're missing?  Performance penalties, memory 
> consumption, anything else?

I would expect a window function to be better, not needing unnest(). I'd 
also expect in practice the algorithm needing to go over all of the rows 
is going to be the major cause of use of memory or CPU, which is the 
same with window functions and aggregates.

But, I haven't benchmarked any of this.