[postgis-users] Fwd: [Mapserver-users] WMS GetFeatureInfo on PostGIS slow?

[Bart van den Eijnden]

Solved it, stupid me. Feature info is running smooth now.

I was running in the wrong Apache server (I have 2 installed, but with a 
different version of mapserv).

I will be joining one of the PostGIS workshops for sure in Ottawa :)

But the index on the oid field is not in the MUM 2003 workshop document if 
I am not mistaken.

Thanks alot. See you in Ottawa.

Best regards,
Bart

On Tue, 01 Jun 2004 23:30:17 +0200, Bart van den Eijnden 
<bartvde at xs4all.nl> wrote:

> Hi Paul,
>
> Oops, I did this, followed by a vacuum analyze, and now no maps are 
> coming at all :(
> (Restarting the db did not help).
>
> Mapserver gives me an internal server error, nothing special in the 
> Apache error log.
>
> Yes, I will be in Ottawa and most certainly will buy you a beer.
>
> Any ideas?
>
> Best regards,
> Bart
>
> On Tue, 01 Jun 2004 14:10:14 -0700, Paul Ramsey 
> <pramsey at refractions.net> wrote:
>
>> create index top50_oid_idx on top50 (oid);
>>
>> Are you coming to Ottawa so you can buy me a beer? :)
>>
>> Bart van den Eijnden wrote:
>>
>>> Hi Paul,
>>>
>>> this is my DATA statement:
>>>
>>> DATA "the_geom from top50"
>>>
>>> I have created the following index:
>>> CREATE INDEX top50_geom_idx ON top50 USING GIST (the_geom 
>>> GIST_GEOMETRY_OPS);
>>>
>>> Data was loaded through shp2pgsql.
>>>
>>> Best regards,
>>> Bart
>>>
>>> On Tue, 01 Jun 2004 13:59:19 -0700, Paul Ramsey 
>>> <pramsey at refractions.net> wrote:
>>>
>>>> What is your DATA statement, and what indexes do you have on your 
>>>> table?
>>>>
>>>> Bart van den Eijnden wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> I got no answer on the Mapserver list, maybe somebody here knows the 
>>>>> answer. I am using the Win32 snapshot from Mark in combination with 
>>>>> Mapserver 4.2 b3.
>>>>>
>>>>> Is the performance problem caused by the fact that the cursor is not 
>>>>> used for some reason?
>>>>>
>>>>> Thanks in advance.
>>>>>
>>>>> Best regards,
>>>>> Bart
>>>>>
>>>>> ------- Forwarded message -------
>>>>> From: Bart van den Eijnden <bartvde at xs4all.nl>
>>>>> To: "mapserver-users at lists.gis.umn.edu" 
>>>>> <mapserver-users at lists.gis.umn.edu>
>>>>> Subject: [Mapserver-users] WMS GetFeatureInfo on PostGIS slow?
>>>>> Date: Sun, 30 May 2004 14:53:37 +0200
>>>>>
>>>>>> Hi list,
>>>>>>
>>>>>> I have started my first adventures with PostGIS and I am quite 
>>>>>> impressed by the speed with which the map is drawn.
>>>>>>
>>>>>> I have a polygon layer with 1,5 million records.
>>>>>>
>>>>>> As I said, map performance is good. But when I use GetFeatureInfo 
>>>>>> on the PostGIS layer, it takes more than 5 seconds for Mapserver to 
>>>>>> come back with the result. In the PostgreSQL console I see:
>>>>>>
>>>>>> ERROR:  cursor "mycursor" does not exist
>>>>>>
>>>>>> Is this normal performance for GetFeatureInfo on PostGIS, or can I 
>>>>>> tweak something to speed this up? I am using Mapserver 4.2 beta 3, 
>>>>>> as this is the latest Win binary available.
>>>>>>
>>>>>> Thanks in advance.
>>>>>>
>>>>>> Best regards,
>>>>>> Bart
>>>>>> _______________________________________________
>>>>>> Mapserver-users mailing list
>>>>>> Mapserver-users at lists.gis.umn.edu
>>>>>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>
>



--