[postgis-users] newby performance load to mapserver compared toshapefile

francesco.pirotti at unipd.it francesco.pirotti at unipd.it
Wed Jul 18 05:02:27 PDT 2007

I will do that right now, just have to know... what do you mean "\d
<table> output" and the exact queries you mean everything except the
"using unique" keywords which I believe are only for mapserver (they are
not SQL syntax right?).

Francesco Pirotti

> * francesco.pirotti at unipd.it (francesco.pirotti at unipd.it) 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list