Hello, O.k. no one seemed interested in our 8.2 issues, so I thought i would test on -head ;)
[EMAIL PROTECTED]:/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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
