[postgis-users] Re: Postgis too slow

[shpr@libero.it]

Even if I insert the following line

FILTER "1=2"

postgis takes 1 minute before to send me a negative response!!!!!!



> Hi, I don't know if this is a memory problem (can be can be), but if 
> this is a memory problem:
> why if I query directly from postgresql all is ok?
> 
> if I execute spatial query from postgresql the response time is always
 
> very small.
> 
> I don't know what to say ....
> 
> Now, I'll re-analyze the problem.
> 
> Thanks.
> 
> > How much memory does your machine have?  You could be going into swa
p
> > death.  What does top say its doing for those 3 minutes?  
> > 
> > dave
> > 
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >