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 _______________________________________________ Qgis-developer mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
