Insert time

Hi everyone,

I am running a test with 1 thread calling a stored
procedure in an endless loop. The stored procedure
inserts 1000 records in a table that does not have
indexes or constraints.
In the log file I see that the time to execute the
procedure sometimes it jumps from 100 ms to 700 ms.
The auto-vacuum is turned off.
Can anyone give me some details about this?

Thanks a lot,

17221%2008-04-01 09:22:53 ESTLOG:  statement: select *
from testinsert(100001001,1000)
17221%2008-04-01 09:22:53 ESTLOG:  duration: 111.654
ms
17223%2008-04-01 09:22:53 ESTLOG:  statement: select *
from testinsert(100001001,1000)
17223%2008-04-01 09:22:54 ESTLOG:  duration: 710.426
ms


      __________________________________________________________________
Ask a question on any topic and get answers from real people. Go to Yahoo! Answers and share what you know at
http://ca.answers.yahoo.com