Re: difference in query performance due to the inclusion of a polygon geometry field - Mailing list pgsql-general

From ivan marchesini
Subject Re: difference in query performance due to the inclusion of a polygon geometry field
Date
Msg-id 1354281924.6704.86.camel@beedo
Whole thread Raw
In response to Re: difference in query performance due to the inclusion of a polygon geometry field  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Hi

thanks for all your answers.

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?

ivan and mauro



--
Ti prego di cercare di non inviarmi files .dwg, .doc, .xls, .ppt.
Preferisco formati liberi.
Please try to avoid to send me .dwg, .doc, .xls, .ppt files.
I prefer free formats.
http://it.wikipedia.org/wiki/Formato_aperto
http://en.wikipedia.org/wiki/Open_format

Ivan Marchesini
Perugia (Italy)
Socio fondatore GFOSS "Geospatial Free and Open Source Software" http://www.gfoss.it
e-mail: ivan.marchesini@irpi.cnr.it
        ivan.marchesini@gmail.com
fax (mailfax): +39 1782092534
jabber: geoivan73@jabber.org
skype: geoivan73

Attachment

pgsql-general by date:

Previous
From: François Beausoleil
Date:
Subject: When is archive_cleanup called?
Next
From: Piviul
Date:
Subject: SETOF come ritorno delle funzioni