[postgis-users] function speed

I wonder if someone can perhaps shed so light on a very strange issue. I'm not sure if this is a postgis or postgres question. I've written a function that takes a geometry and a couple of other arguments then in the function I simply select from a table with 6.5mil rows using WHERE

Re: [postgis-users] function speed

On Thu, 2007-05-31 at 17:47 +0200, Christo Du Preez wrote: I wonder if someone can perhaps shed so light on a very strange issue. I'm not sure if this is a postgis or postgres question. I've written a function that takes a geometry and a couple of other arguments then in the function I

[postgis-users] Re: Slow spatial join

Thank you for suggestions, but unfortunately it didn´t help using Contains. The region data is a standard country map (i also tried with another country dataset), but same result. I have also tried with other point data, but same slow response. I tried to do the join with Esri ArcMap and it

RE: [postgis-users] function speed

Christo, If its not too forward to ask of you. Could you let us know the full plpgsql create function you have and also an example sql statement in which you are calling the function? Its kind of hard to think of workarounds when only seeing part of the story. Thanks, Regina

[postgis-users] Support for PostGIS/PostgreSQL

I can´t help you with your Russian problems! Why don´t you help me with my question about slow spatial join at [postgis-users]! /Anders ___ postgis-users mailing list postgis-users@postgis.refractions.net

[postgis-users] Support for PostGIS/PostgreSQL

Sorry for the rude tone in the last post It was supposed to be a private post... to an old friend. /Anders ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users