[postgis-users] toTopoGeom performance tips

[Sandro Santilli]

On Mon, May 14, 2012 at 05:25:47PM +1000, Luca Morandini wrote:
> On 05/14/2012 04:39 PM, Sandro Santilli wrote:

> >I've noticed that a single transaction takes a lot more time than multiple.
> >This is because toTopoGeometry is an hard database writer and the transaction
> >must keep track of all changes to eventually roll-back. The presence of
> >sub-transactions make things somewhat worst.
> 
> I see... well, having transactions similar to those in Oracle
> certainly would not have hurt here.

Please run the benchmark before jumping to conclusions.
Looking forward for your numbers.

--strk; 

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'