[postgis-users] Topology performance test

[Luca Morandini]

On 06/19/2012 08:25 PM, Sandro Santilli wrote:
>>
>> Am I doing something wrong ?
>
> Probably. I don't use the extension model (as I find it more limited while
> upgrading between SVN revisions) so I don't really know _what_,

I didm't use the extensions, I just ran postegis.sql and spatial_ref_sys.sql on a 
newly created database.


> but I guess
> a ```SELECT postgis_full_version()``` would tell you more (procs need
> upgrade?)

Here you are:
POSTGIS="2.1.0SVN r9949" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.7.1, 23 September 
2009" LIBXML="2.7.6" TOPOLOGY

Therefore, PostGIS has been upgraded, but GEOS is still the old version, which is 
rather odd, since:
/usr/local/lib/libgeos.so -> libgeos-3.3.4.so
/usr/lib/libgeos.so -> libgeos-3.1.0.so

...and:
/usr/local/bin/geos-config --version
3.3.4

...and I specifed the GEOS version to use (3.3.4) during PostGIS build:
./configure --without-raster --with-geosconfig=/usr/local/bin/geos-config


> Mind you: once figured out, I expect you to provide much more
> _detailed_ profiling ! :)

NP.

Regards,

Luca Morandini
Data Architect - AURIN project
Department of Computing and Information Systems
University of Melbourne
Tel. +61 03 903 58 380
Skype: lmorandini