[postgis-users] Speed issues again

Paul Ramsey pramsey at refractions.net
Thu May 6 15:05:53 PDT 2004


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
      \_



More information about the postgis-users mailing list