<div dir="ltr"><div style="font-size:large" class="gmail_default">Hi,<br><br></div><div style="font-size:large" class="gmail_default">Have you checked in the tab "Rendering" of your layer properties the checkbox about "Realize simplification by the provider if possible" (or a text similar, as I just translated from french...).<br></div><div style="font-size:large" class="gmail_default">It can make a huge difference for smal scales like 1:500000, because data is simplified server-side and then downloaded.See: <a href="https://github.com/qgis/QGIS/pull/2410#issuecomment-160987344">https://github.com/qgis/QGIS/pull/2410#issuecomment-160987344</a><br><br></div><div style="font-size:large" class="gmail_default">Regards<br></div><div style="font-size:large" class="gmail_default">Michaël<br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-09-08 17:12 GMT+02:00 Paolo Cavallini <span dir="ltr"><<a href="mailto:cavallini@faunalia.it" target="_blank">cavallini@faunalia.it</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">Il 08/09/2016 17:09, Pietro Rossin ha scritto:<br>
> Thanks Paolo<br>
><br>
> This is the table:<br>
><br>
> CREATE mytable_3045<br>
> (<br>
>   id serial NOT NULL,<br>
>   geom geometry(MultiPolygonZ,3045),<br>
>   nome character varying(255),<br>
>   cod_istat character varying(255),<br>
>   CONSTRAINT mytable_3045_pkey PRIMARY KEY (id)<br>
> )<br>
> WITH (<br>
>   OIDS=FALSE<br>
> );<br>
<br>
</span>Certainly varchar can be smaller, this would save ome byte, but I'd not<br>
expect dramatic improvements. Why geomZ?<br>
Is the geom in single or double precision?<br>
<span class="im HOEnZb">All the best.<br>
--<br>
Paolo Cavallini - <a href="http://www.faunalia.eu" rel="noreferrer" target="_blank">www.faunalia.eu</a><br>
QGIS & PostGIS courses: <a href="http://www.faunalia.eu/training.html" rel="noreferrer" target="_blank">http://www.faunalia.eu/<wbr>training.html</a><br>
</span><div class="HOEnZb"><div class="h5">______________________________<wbr>_________________<br>
Qgis-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/qgis-<wbr>developer</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/qgis-<wbr>developer</a></div></div></blockquote></div><br></div>