[postgis-users] Insert performance issues

[Nicolas RIBOT]

Hi Dave,

We also noticed very good performance on Postgis on our previous
databases.
That's why I sent this email this time: i wanted to understand the
reason of the bottleneck.

As a first clue, seven indices on the same table seems to be too much
:-)

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

Yes, I could send it to you, but the actual table already contains 140
000 polygons. The SQL scripts is about 300 Mb.

Inserting/updating/deleting data in this table seems to be the problem,
as I saw that on a fresh, empty table, inserts are pretty fast.

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

You are right. The 1mb file I was talking about contained only "small"
polygons". Big ones fit in 6 to 10 Mb text files

Thanx
Nicolas