Insert time

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux