[postgis-users] Considerations on performance: union on 59000geometries

Paragon Corporation lr at pcorp.us
Mon Jul 20 11:40:04 PDT 2009

Which version  of PostGIS are you using.  The upcoming 1.4 is much much
faster and may do the trick for you.  Its in rc2 now.  Ready to release any

There is no way the 1.3 will complete with 59,000 in one go.


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Juan
Pedro Pérez Alcántara
Sent: Monday, July 20, 2009 2:10 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Considerations on performance: union on

Hello everybody,

today I tried to perform a union on 59000 geometries, but the operation
seems not to complete. In no way I'm an expert in PostgreSQL/PostGIS
optimization, and for sure my system is not in the perfect shape to address
such operations with elegance.

My questions are:

* should PostGIS be able to perform this operation if properly optimized?

* could you please advise me some piece of documentation for learning about
PostgreSQL / PostGIS optimization?

I read somewhere that the french cartographic service has migrated to
PostGIS, so I have no doubt that this have to be possible to achieve, and
speaks loud about the importance of optimization issues.


Juan Pedro Pérez Alcántara

postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list