From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Possible BUG in -head with stats |
Date: | 2007-03-01 06:36:12 |
Message-ID: | 45E6745C.9010005@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
O.k. no one seemed interested in our 8.2 issues, so I thought i would
test on -head ;)
jd(at)scratch:/tmp/pg$ strace -c -p 3545
Process 3545 attached - interrupt to quit
Process 3545 detached
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
59.45 0.178412 3 70176 10128 poll
22.68 0.068083 7 10294 rename
12.05 0.036158 4 10294 open
2.98 0.008929 1 10294 close
1.68 0.005051 0 60040 recvfrom
0.65 0.001954 0 10294 setitimer
0.46 0.001386 0 20588 write
0.03 0.000090 0 10294 mmap
0.02 0.000065 0 10294 munmap
0.00 0.000000 0 10294 fstat
0.00 0.000000 0 1 brk
0.00 0.000000 0 10294 10128 rt_sigreturn
0.00 0.000000 0 10302 getppid
------ ----------- ----------- --------- --------- ----------------
100.00 0.300128 243459 20256 total
THe rename is being called 10294 times over 1 minute 56 seconds. This is
on the same machine and using the same test as mention here:
http://archives.postgresql.org/pgsql-hackers/2007-02/msg01902.php
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
From | Date | Subject | |
---|---|---|---|
Next Message | Zoltan Boszormenyi | 2007-03-01 07:04:53 | Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ? |
Previous Message | Tom Lane | 2007-03-01 06:17:03 | Re: Resumable vacuum proposal and design overview |