Re: [GENERAL] difference in query performance due to the inclusion of a polygon geometry field

2012-12-02 Thread ivan marchesini
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.marches...@irpi.cnr.it ivan.marches...@gmail.com fax (mailfax): +39 1782092534 jabber: ge

Re: [GENERAL] difference in query performance due to the inclusion of a polygon geometry field

2012-11-30 Thread Ivan Marchesini
suppose it is not. :-) Thanks Ivan inviato da smartphone Il giorno 30/nov/2012 15:16, "Albe Laurenz" ha scritto: > ivan marchesini wrote: > > Concerning the problem of the same "running time" I'm really surprised > > but I can confirm that the EX

Re: [GENERAL] difference in query performance due to the inclusion of a polygon geometry field

2012-11-30 Thread ivan marchesini
hanks... 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/Op

[GENERAL] difference in query performance due to the inclusion of a polygon geometry field

2012-11-30 Thread ivan marchesini
rt. A similar task performed on two similar tables (both larger than the previous ones!!) but including and excluding a PostGIS geometric POINT (!!) field instead of POLYGON one, doesn't result in significant query execution time difference. Do you have please any suggestion to improve our q