On Thu, Aug 02, 2012 at 05:41:23PM -0400, Jean-Daniel Sylvain wrote: > Hi, > > Is it possible to create overviews in postgis to optimise the speed of > display for very big vectorial dataset (10 000 000) ? > > The aim is to be able to look quickly the dataset via a GIS tool like > Quantum GIS or GV SIG or any suggestions.
You can adopt different strategies for that. For puntual data I'd recommend a random sample. For lineal and polygonal I'd simplify on the fly. Note that the sampling approach affects attributes too... --strk; ,------o-. | __/ | Delivering high quality PostGIS 2.1 | / 2.1 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users