From: Chris Hoover <revoohc@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: What happens on a commit?
Date: Tue, 22 May 2007 14:10:52 -0400
Message-ID: <1d219a6f0705221110v6718eaa1w67e17ac0c940772a@mail.gmail.com> (raw)
In-Reply-To: <1d219a6f0705221025i1c1d036eq4769b133cac7499@mail.gmail.com>
References: <1d219a6f0705221025i1c1d036eq4769b133cac7499@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: revoohc@gmail.com
Subject: Re: What happens on a commit?
In-Reply-To: <1d219a6f0705221110v6718eaa1w67e17ac0c940772a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox