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

[Juan Pedro Pérez Alcántara]

Thank you. I'll try.

Regards,

Juan Pedro Pérez Alcántara

On Mon, 2009-07-20 at 14:40 -0400, Paragon Corporation wrote:
> 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
> day.
> 
> There is no way the 1.3 will complete with 59,000 in one go.
> 
> Leo
> 
> -----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
> 59000geometries
> 
> 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?
> and
> 
> * 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.
> 
> Regards,
> 
> Juan Pedro Pérez Alcántara
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>