[postgis-users] Topology performance test

Luca Morandini lmorandini at ieee.org
Tue Jun 19 01:33:47 PDT 2012


Folks,

as promised, I ran performance tests on topology creation against the latest 
PostGIS (see a previous post of mine), but the processing time did not change from 
PostGIS 2.0.0 and Geos 3.3.3.

Details:
- Ubuntu 10.04.4 LTS 64bits
- PostgreSQL 9.1.3
- libgeos 3.3.4
- PostGIS rev. 9949
- Data: 142 polygons, 386.387 points, 2.721 points on avg for each polygon

One caveat: I built PostGIS from trunk, applied it to a new database and it 
worked... but it still gives me 2.0.0 as version:
SELECT name, default_version,installed_version
FROM pg_available_extensions WHERE name LIKE 'postgis%' ;
        name       | default_version | installed_version
------------------+-----------------+-------------------
  postgis          | 2.0.0           |
  postgis_topology | 2.0.0           |

Am I doing something wrong ?

Regards,

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




More information about the postgis-users mailing list