[postgis-users] Vector overviews in postgis

Sandro Santilli strk at keybit.net
Thu Aug 2 21:47:43 PDT 2012

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


  |   __/  |    Delivering high quality PostGIS 2.1
  |  / 2.1 |    http://strk.keybit.net - http://vizzuality.com

More information about the postgis-users mailing list