[postgis-users] newby performance load to mapserver compared toshapefile
sfrost at snowman.net
Wed Jul 18 04:13:50 PDT 2007
* 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
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.
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 189 bytes
Desc: Digital signature
More information about the postgis-users