> 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 scan.
signature.asc
Description: This is a digitally signed message part