Hi Laurenz Thanks but as I said I have tried using psql directly on the server. And still there is a strong difference between the queries execution time with and without the geometric field. May be it is a problem of clients but I obtain the same problem with pgadmin, psql and other servers. So I suppose it is not. :-)
ivan marchesini wrote: > Concerning the problem of the same "running time" I'm really surprised > but I can confirm that the EXPLAIN ANALIZE time is different from the > query execution time. > probably it happen something like this: > http://bytes.com/topic/postgresql/answers/422841-explain-analyze-total-runtime-walltime > But we have tried to remove the fk constraints without any improvement > > Concerning the client problem, e have tried to execute the query > directly on the server using psql. > The difference is still in the order of seconds: around 10 ms VS 5000 ms > > many thanks... > > other suggestions?
As I said -- could the time be spent on the client?
