Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 61D039FBCB9 for ; Tue, 22 May 2007 15:13:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 23997-02 for ; Tue, 22 May 2007 15:13:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ik-out-1112.google.com (ik-out-1112.google.com [66.249.90.182]) by postgresql.org (Postfix) with ESMTP id 3E48E9FBCCC for ; Tue, 22 May 2007 15:10:53 -0300 (ADT) Received: by ik-out-1112.google.com with SMTP id b35so1173866ika for ; Tue, 22 May 2007 11:10:52 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=jjNQvLkL8OJD7OuBPz4PxQUQ3OLJn1JY/RL2s/Ueo7OZlcM8UJwFqAGUNrnXAplUB1RE7xp/9lQfyIrvZyFla+27GrBAnXvNFzm8fOMvegANDAyozpkEDhxgeykQQVK4e7+0p/OsEMDyobhKopEieEtDQ4pk0OLw0QhCT9910Js= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=FztgIr/zQiU5lLwt7WnGi3moPxJ0nOQb4TmvQdwACttDSzgnyOsaIQjpdVVXsyGhSHScXdEqV5KfvlzILHouyytOdbEymNF6tTbPZqIKh+hiihwmOlbB9vtP2xO8C2uza7e0WVf7LNO4pL9t3NDQK9jXW6fMe6AjETchT9rnArM= Received: by 10.78.188.10 with SMTP id l10mr1526870huf.1179857452272; Tue, 22 May 2007 11:10:52 -0700 (PDT) Received: by 10.78.201.16 with HTTP; Tue, 22 May 2007 11:10:52 -0700 (PDT) Message-ID: <1d219a6f0705221110v6718eaa1w67e17ac0c940772a@mail.gmail.com> Date: Tue, 22 May 2007 14:10:52 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: Re: What happens on a commit? In-Reply-To: <1d219a6f0705221025i1c1d036eq4769b133cac7499@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_77242_29168976.1179857452195" References: <1d219a6f0705221025i1c1d036eq4769b133cac7499@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/225 X-Sequence-Number: 25545 ------=_Part_77242_29168976.1179857452195 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_77242_29168976.1179857452195 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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

------=_Part_77242_29168976.1179857452195--