[postgis-users] ordering spatial data in tables

[Ben Madin]

G'day all,

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

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.

cheers

Ben



-- 

Ben Madin
REMOTE INFORMATION

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...