Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 5F10E2E002C for ; Tue, 1 Apr 2008 12:38:56 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 75848-06 for ; Tue, 1 Apr 2008 12:38:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from n69.bullet.mail.sp1.yahoo.com (n69.bullet.mail.sp1.yahoo.com [98.136.44.41]) by developer.postgresql.org (Postfix) with SMTP id DD9B02E006F for ; Tue, 1 Apr 2008 12:38:44 -0300 (ADT) Received: from [216.252.122.218] by n69.bullet.mail.sp1.yahoo.com with NNFMP; 01 Apr 2008 15:38:39 -0000 Received: from [69.147.65.164] by t3.bullet.sp1.yahoo.com with NNFMP; 01 Apr 2008 15:38:39 -0000 Received: from [127.0.0.1] by omp409.mail.sp1.yahoo.com with NNFMP; 01 Apr 2008 15:38:38 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 858348.95795.bm@omp409.mail.sp1.yahoo.com Received: (qmail 66047 invoked by uid 60001); 1 Apr 2008 15:38:38 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.ca; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=VGng6DtKfdIkDbWJbz1JH2bQhqn623lstC/0stLp+5MV0OG+YsPZDI15KSKfEFbqq33yeT3EagAGuIXDPup+OQC+tJRcwK/lDSkNn1npdMv84Fm/s7APo6JRSVhRPVwn0sLdrdPyd3EnWkbjf8EH7KWFZGjkdSAJ00KzcXEHO9A=; X-YMail-OSG: vBvASQoVM1nO4NARIJ.3oTApJccExiyC4LKZNYgGhipWF7ppYbzUt8Vm1VCPAzefvY3PHOQ_YjEEQwUNZTDeqzNgI9y_LmRvGY7I7MAafAM- Received: from [207.164.182.8] by web45106.mail.sp1.yahoo.com via HTTP; Tue, 01 Apr 2008 11:38:38 EDT Date: Tue, 1 Apr 2008 11:38:38 -0400 (EDT) From: Ioana Danes Subject: Insert time To: PostgreSQL Performance MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <507938.65426.qm@web45106.mail.sp1.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/8 X-Sequence-Number: 29501 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