> 20,000 items            Takes on average 0.078seconds/room
> 385,000 items          Takes on average .11seconds/room
> 690,000 items          takes on average .270seconds/room
> 1,028,000 items       Takes on average .475seconds/room
> As can be seen the time taken to process each room increases. A commit 
> occurs when a room has been copied.

It probably isn't the insert that is getting slower, but a select. 
Foreign keys to growing tables will exhibit this behaviour.

Since the time is doubling with the number of items, you might want to
check for a SELECT working with a sequential scan rather than an index

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to