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. :-)
Thanks Ivan inviato da smartphone Il giorno 30/nov/2012 15:16, "Albe Laurenz" <laurenz.a...@wien.gv.at> ha scritto: > 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? > > Yours, > Laurenz Albe >
