[Qgis-developer] Qgis and huge amount of data opening "small" postgis layer

Paolo Cavallini cavallini at faunalia.it
Thu Sep 8 08:12:02 PDT 2016


Il 08/09/2016 17:09, Pietro Rossin ha scritto:
> Thanks Paolo
> 
> This is the table:
> 
> CREATE mytable_3045
> (
>   id serial NOT NULL,
>   geom geometry(MultiPolygonZ,3045),
>   nome character varying(255),
>   cod_istat character varying(255),
>   CONSTRAINT mytable_3045_pkey PRIMARY KEY (id)
> )
> WITH (
>   OIDS=FALSE
> );

Certainly varchar can be smaller, this would save ome byte, but I'd not
expect dramatic improvements. Why geomZ?
Is the geom in single or double precision?
All the best.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html


More information about the Qgis-developer mailing list