Re: What happens on a commit?

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: What happens on a commit?
Date: 2007-05-22 18:10:52
Message-ID: 1d219a6f0705221110v6718eaa1w67e17ac0c940772a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Elmers 2007-05-22 19:15:40 Re: Size of logfiles
Previous Message Tom Lane 2007-05-22 17:43:03 Re: preload libraries