Re: What happens on a commit?
От | Chris Hoover |
---|---|
Тема | Re: What happens on a commit? |
Дата | |
Msg-id | 1d219a6f0705221110v6718eaa1w67e17ac0c940772a@mail.gmail.com обсуждение исходный текст |
Ответ на | What happens on a commit? ("Chris Hoover" <revoohc@gmail.com>) |
Ответы |
Re: What happens on a commit?
|
Список | pgsql-admin |
I found an e-mail showing how to strace and here is what I have found. Does it help/mean anything to those who can decode this?
We are installing PostgreSQL from the official rpms.
Chris
time strace -c -p 2690
Process 2690 attached - interrupt to quit
Process 2690 detached
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
42.80 13.003288 251 51790 recv
17.47 5.306686 30 175916 send
16.23 4.930150 14 342118 stat64
10.26 3.117593 18 174533 write
8.22 2.497767 9 292070 gettimeofday
2.63 0.798323 462 1727 fdatasync
1.83 0.554745 6 92179 _llseek
0.46 0.138782 11 12896 brk
0.09 0.026920 19 1433 semop
0.02 0.006847 4 1734 time
0.00 0.000494 16 31 read
0.00 0.000253 23 11 open
0.00 0.000088 7 12 close
0.00 0.000013 13 1 kill
0.00 0.000010 10 1 sigreturn
0.00 0.000001 1 1 fsync
------ ----------- ----------- --------- --------- ----------------
100.00 30.381960 1146453 total
real 27m21.090s
user 0m5.379s
sys 0m23.073s
We are installing PostgreSQL from the official rpms.
Chris
time strace -c -p 2690
Process 2690 attached - interrupt to quit
Process 2690 detached
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
42.80 13.003288 251 51790 recv
17.47 5.306686 30 175916 send
16.23 4.930150 14 342118 stat64
10.26 3.117593 18 174533 write
8.22 2.497767 9 292070 gettimeofday
2.63 0.798323 462 1727 fdatasync
1.83 0.554745 6 92179 _llseek
0.46 0.138782 11 12896 brk
0.09 0.026920 19 1433 semop
0.02 0.006847 4 1734 time
0.00 0.000494 16 31 read
0.00 0.000253 23 11 open
0.00 0.000088 7 12 close
0.00 0.000013 13 1 kill
0.00 0.000010 10 1 sigreturn
0.00 0.000001 1 1 fsync
------ ----------- ----------- --------- --------- ----------------
100.00 30.381960 1146453 total
real 27m21.090s
user 0m5.379s
sys 0m23.073s
В списке pgsql-admin по дате отправления: