[mapserver-users] long-running postgres queries initiated by mapserver

2010-12-21 Thread mattmendick
Hi All- I'm running mapserver 5.6.3 under centos 5.4, using fastcgi. I'm using postgres as the data storage container, and mapserver is primarily serving WFS requests. Sometimes, people do WFS queries that take a very long time (searching for virginia on a nation-wide layer) and eventually

Re: [mapserver-users] long-running postgres queries initiated by mapserver

2010-12-21 Thread Carlos Ruiz
: Tue, December 21, 2010 8:48:19 AM Subject: [mapserver-users] long-running postgres queries initiated by mapserver Hi All- I'm running mapserver 5.6.3 under centos 5.4, using fastcgi. I'm using postgres as the data storage container, and mapserver is primarily serving WFS requests. Sometimes

RE: [mapserver-users] long-running postgres queries initiated by mapserver

2010-12-21 Thread Matt Mendick
To: mapserver-users@lists.osgeo.org Sent: Tue, December 21, 2010 8:48:19 AM Subject: [mapserver-users] long-running postgres queries initiated by mapserver Hi All- I'm running mapserver 5.6.3 under centos 5.4, using fastcgi. I'm using postgres as the data storage container, and mapserver is primarily

Re: [mapserver-users] long-running postgres queries initiated by mapserver

2010-12-21 Thread Carlos Ruiz
@lists.osgeo.org mapserver-users@lists.osgeo.org Sent: Tue, December 21, 2010 10:43:46 AM Subject: RE: [mapserver-users] long-running postgres queries initiated by mapserver Carlos, Thank you for your response, and indeed the tables do have indices. The spatial search is just fine and comes back