[Qgis-user] connecting to large Postgis tables...

[Bernhard Ströbl]

Hi,

did you tick "use estimated table metadata" in the PostGIS connection's 
settings?
What happens if you hit "Stop" after clicking on "Connect"?

Bernhard

Am 17.01.2013 06:19, schrieb Chris Nicholas:
> Hi -
>
>
> I loaded and indexed a pretty healthy PostGIS table, and did all the right things in terms of disk/table partitioning, etc..
> :-)
>
>
> but still, when I tried connecting with QGIS, it was *really* slow...
>
> :-(
>
> turning on Postgres debugging, I noticed that QGIS appears to be issuing a silly:
> "select extent(the_geom) from my_big_table" , i.e. a full table scan, on connect ...
>
> um...er... what is that about, and can it be disabled?
>
> thanks!
> Chris
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user