| From: | Ioana Danes <ioanasoftware(at)yahoo(dot)ca> |
|---|---|
| To: | PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Insert time |
| Date: | 2008-04-01 15:38:38 |
| Message-ID: | 507938.65426.qm@web45106.mail.sp1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hell, Robert | 2008-04-01 15:48:04 | Re: Cursors and different settings for default_statistics_target |
| Previous Message | Tom Lane | 2008-04-01 15:30:05 | Re: Cursors and different settings for default_statistics_target |