[postgis-users] debug_level options?

David Blasby dblasby at refractions.net
Mon Jun 9 09:53:13 PDT 2003


I think this is happening because you are using Mapserver to do queries 
to a postgis layer.

The old version of mappostgis.c determined the column in an arbitrary 
SQL statement by executing a

EXPLAIN VERBOSE <query>;

This command does send a NOTICE message to mapserver AND the postgresql 
console.  This doent really add very much processing time.

Make sure you have an spatial index and an index on your unique column.

The new version of mappostgis.c doesnt do this, so it will be silent.

dave




More information about the postgis-users mailing list