Hi Justin,
I found that my problem is on the postgis side of things. By looking at the
sql sent from geoserver, I can see that my wfs request works fine because it
is not looking for the bounding box. That is, the query from the wfs works
well:
SELECT "oid", encode(asBinary(force_2d("the_geom"),'XDR'),'base64') FROM
"public"."obs_subset" WHERE "sci_name" = 'Scolopax minor';
...but the wms query doesn't (actually, it does come up after about 10
minutes):
SELECT "oid", encode(asBinary(force_2d("the_geom"),'XDR'),'base64') FROM
"public"."obs_subset" WHERE ((TRUE AND "sci_name" = 'Scolopax minor') AND
"the_geom" && GeometryFromText('POLYGON ((-6190456.43153527 -4590000,
-6190456.43153527 4590000, 4890456.43153527 4590000, 4890456.43153527
-4590000, -6190456.43153527 -4590000))', 102008));
I have a spatial index, and the query planner says it is using the index.
I've run vacuum analyze and update_geometry_stats (we're using pg 7.4 and
postgis 1.2) The table is all point data, again about 13 million records.
This query returns about 4500 rows. Should it be this slow? I did note
that each of the points does not have a bbox (hasbbox=f)....but I wouldn't
think that would matter for points.
Thanks,
Steve
-----Original Message-----
From: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Sent: Thursday, July 24, 2008 10:14 PM
To: Josh Marcus
Cc: Stephen Crawford; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] max features
Any chance one of you can include the log of the query being made against
postgis during the WMS request. Definitely seems something is a miss. And as
I mentioned before a dump of some sample data would definitely help us debug
this one.
-Justin
Josh Marcus wrote:
Stephen,
We are having a similar issue that may be related. We have a postgis
Feature Type with about 800k features. We notice a sharp decrease in
performance when we send a WMS request with a filter that returns ~50k
features. On our server, we can handle 50-80k feature requests (with
4-5 seconds delay) but as the number of features increase the delays
get significantly longer (45 seconds). Similarly, the postgis table
doesn't seem to be the problem, as I can render all 800k points in
MapServer with only a few seconds of processing max.
Let me know if you resolve your issue, and if you are able to get good
performance rendering your points. Thanks!
--j
On Tue, Jul 22, 2008 at 10:33 AM, Stephen Crawford <src176@anonymised.com
<mailto:src176@anonymised.com>> wrote:
All,
I currently have a postgis Feature Type with approx 13 million point
features. My geoserver instance is set for 1 million max features.
When I
send a WMS request with a filter that should return about 40,000
features,
geosever just hangs....the same query is returned quickly when I hit
postgis
directly. My question is: does the Maximum Features number refer
to the
total number of features in the Feature Type (13 million) or the
number
returned for the GetMap request (40,000)?
Thanks,
Steve
Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win
great prizes
Grand prize is a trip for two to an Open Source event anywhere in
the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
<http://moblin-contest.org/redirect.php?banner_id=100&url=/>
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
!DSPAM:4007,488607db260511637810514!
----------------------------------------------------------------------
--
----------------------------------------------------------------------
--- This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge Build the coolest Linux based applications with Moblin SDK &
win great prizes Grand prize is a trip for two to an Open Source event
anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
!DSPAM:4007,488607db260511637810514!
----------------------------------------------------------------------
--
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
!DSPAM:4007,488607db260511637810514!
--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com