[Qgis-developer] Re: Wroclaw taking several minutes to load a single postgis polygon

[Jürgen E. Fischer]

Hi,

On Tue, 13. Sep 2011 at 06:37:26 +0200, Andreas Neumann wrote:
> It sounds to me like it is trying to determine the primary key.

It's trying to determine the geometry type at that particular query. 
Does the table have an entry in geometry_columns with a
geometrytype<>'GEOMETRY'?
 
> On 09/13/2011 04:15 AM, Tim Keitt wrote:
> > Yes. Loading one postgis table causes a scan of data related to all
> > other tables in the database. The query below appears in the
> > postgresql log, but it is not the table loaded into qgis. The query
> > took more than 6 minutes.
> > 
> > THK
> > 
> > 2011-09-12 21:09:34 CDT LOG:  duration: 394152.953 ms  statement:
> > select distinct case when geometrytype("the_geom") IN
> > ('POINT','MULTIPOINT') THEN 'POINT' when geometrytype("the_geom") IN
> > ('LINESTRING','MULTILINESTRING') THEN 'LINESTRING' when
> > geometrytype("the_geom") IN ('POLYGON','MULTIPOLYGON') THEN 'POLYGON'
> > end from "public"."dual_cmtc_geom"


Jürgen

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-20
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502