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

[Bart van den Eijnden]

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
>>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>>
>
>



--