[postgis-users] Speed issues again

[Zamil Murji]

Thanks Paul for the quick reply,
As you can see from the \d on my main_well1 table in dev, I have already created those indexes. Both prod and dev have an index on oid.

Indexes: main_well1_oid_idx btree (oid),
         main_well1_the_geom_idx gist (the_geom),
         main_well1_uwi_idx btree (uwi)
Check constraints: "$1" (srid(the_geom) = -1)
                   "$2" ((geometrytype(the_geom) = 'POINT'::text) OR (the_geom IS NULL))


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Paul
Ramsey
Sent: Thursday, May 06, 2004 4:06 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Speed issues again


If you mapserver is slow when running a query, the cause is almost 
always the lack of an index on the unique column of the database. If you 
declare a unique key in your DATA statement with "USING UNIQUE" then 
that column should have an index. If you do not, then 'oid' should have 
an index (create index thetable_idx on thetable (oid);).

Zamil Murji wrote:

> Hi list,
> I have run into speed issues once again. Please help me debug the situation.
> On my dev box:
... VARIOUS QUERIES ...


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users