* [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
> Takes more than 5 seconds though to show in my mapserver image, around 36
> seconds...

Please post the table definitions including indexes and whatnot (ie:
\d <table> output).  Also, make sure your tables are 'ANALYZE'd.
Also, the mapserver .map file might help.  If you could also turn on
statement logging in the PG backend and then take the *exact* queries
mapserver is running and run them using 'explain analyze' and posting
them here, that would be a great help.

        Thanks,

                Stephen

Attachment: signature.asc
Description: Digital signature

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to