[postgis-users] Problems with Select by Polygon - pgsql75win

Randy Page randy.page at terraverge.com
Tue Aug 3 11:35:16 PDT 2004


I'm using pgsql75win with Mapserver 4.2 CGI on Windows 2000.   Also, I have
vacuumed and analyzed the offending table with no change.

Thanks,

Randy 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of David
Blasby
Sent: Tuesday, August 03, 2004 2:10 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Problems with Select by Polygon - pgsql75win

What version of mapserver and postgresql are you using?

On Tue, 3 Aug 2004 13:59:45 -0400, Randy Page <randy.page at terraverge.com>
wrote:
> Zamil,
> 
> Great idea!  It worked like a charm, and gave me the following (corrected)
> SQL:
> 
> SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
> tracts_c WHERE the_geom && setSRID('BOX3D(-78.83 35.87,-78.7
35.96)'::BOX3D,
> find_srid('','tracts_c','the_geom') )
> 
> This sql executes in less than a second and returns the expected results.
> So, why is mapserver hanging on this?
> 
> Thanks,
> 
> Randy
> 
> 
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Zamil
> Murji
> Sent: Tuesday, August 03, 2004 1:50 PM
> To: PostGIS Users Discussion
> Subject: RE: [postgis-users] Problems with Select by Polygon - pgsql75win
> 
> Why don't you try purposely making a mistake in your data statement. I
like
> to spell my table name wrong. Mapserv will die with an error message that
> gives you the sql statement it was trying to execute. Change all the
> mistakes
> back to the proper table name and run that select statement in postgres.
> Do a query analyze on that...
> 
> Hope that helps.
> Zamil
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Randy
> Page
> Sent: Tuesday, August 03, 2004 11:45 AM
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] Problems with Select by Polygon -
> pgsql75win
> 
> David,
> 
> I can't seem to get to that point due to the timeout.  I even bumped the
> timeout up to 20,000 seconds with no change.   I have been watching the
disk
> & cpu usage on the PostGIS server, and it's doing absolutely nothing
during
> the time the request is taking place.
> 
> Randy
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of David
> Blasby
> Sent: Tuesday, August 03, 2004 1:03 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Problems with Select by Polygon - pgsql75win
> 
> it should be writing it back to your web browser.  Do a "view page
> source...".
> 
> dave
> 
> On Tue, 3 Aug 2004 11:57:55 -0400, Randy Page <randy.page at terraverge.com>
> wrote:
> > Dave,
> >
> > Thanks for the advice.   I tried this, but I am not sure where MS is
> writing
> > the debug info (I am using IIS.)   I looked in the IIS logs, but didn't
> see
> > anything but the basic request.
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
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