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

[Paul Ramsey]

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


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_