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

[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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130116/f2bd0ae7/attachment.html>