[postgis-users] ordering spatial data in tables

Ben Madin ben at remoteinformation.com.au
Tue Jan 6 17:48:43 PST 2009

G'day all,

I'm aggregating data from shapefiles into a table to cover a larger  

My question is, is there any benefit to be gained by ordering the data  
by some sort of spatial representation, ie centroid when retrieving  
the data? Or does the creation of the GiST index obviate the need for  
such a thing.




Ben Madin

t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome   WA   6725

ben at remoteinformation.com.au

							Out here, it pays to know...

More information about the postgis-users mailing list