[postgis-users] Vector overviews in postgis

[Sandro Santilli]

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