From: Ioana Danes <ioanasoftware@yahoo.ca>
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Insert time
Date: Tue, 1 Apr 2008 11:38:38 -0400 (EDT)
Message-ID: <507938.65426.qm@web45106.mail.sp1.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ioanasoftware@yahoo.ca
Subject: Re: Insert time
In-Reply-To: <507938.65426.qm@web45106.mail.sp1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox