[postgis-users] Insert performance issues

[David Blasby]

When I wrote the parser, I did check performance on large polygons (with 
 >100,000 points and >1000 rings).  I thought it was quite fast on our 
really-really slow Solarius machine.  On a 1Ghz linux machine it should 
be very fast.

Could you send me your SQL script (and how to create the table it will 
be inserting into)?

Also, you shouldnt be able to fit a 100,000 point polygon into a 1MB SQL 
file.

dave