| From: | ivan marchesini <ivan(dot)marchesini(at)gmail(dot)com> |
|---|---|
| To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
| Cc: | pgsql-general(at)postgresql(dot)org, Mauro Rossi <mauro(dot)rossi(at)irpi(dot)cnr(dot)it> |
| Subject: | Re: difference in query performance due to the inclusion of a polygon geometry field |
| Date: | 2012-11-30 13:25:24 |
| Message-ID: | 1354281924.6704.86.camel@beedo |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)marchesini(at)irpi(dot)cnr(dot)it
ivan(dot)marchesini(at)gmail(dot)com
fax (mailfax): +39 1782092534
jabber: geoivan73(at)jabber(dot)org
skype: geoivan73
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henry Drexler | 2012-11-30 13:32:22 | Re: query performance, though it was timestamps, maybe just table size? |
| Previous Message | Henry Drexler | 2012-11-30 13:22:07 | query performance, though it was timestamps,maybe just table size? |