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
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
