[postgis-users] Partitionning using geometry

[Mark Wynter]

Hi Remi
I might be off the mark with what you are trying to achieve.

One thing I've experimented with, which is allied to vector tiling, is to assign tile IDs to features, based on various spatial relationships, and to use the "tile id" to index and "subset" the tables prior to doing other "stuff".  Feature IDs mapped to Tile IDs start moving into the realm of Key Value pairs...
Moreover, you could parallelise the Postgis subsetting and map reduce process using R called from Postgis via Pl/r. 

And to make working with R more efficient, have you seen this package that allows you to manipulate R data frames using SQL syntax....

http://www.r-bloggers.com/make-r-speak-sql-with-sqldf/

Food for thought :)