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

[Stephen Frost]

* 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070718/1168986b/attachment.pgp>