Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 271859FB442 for ; Tue, 22 May 2007 16:30:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 22527-04 for ; Tue, 22 May 2007 16:30:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 552E29FB40D for ; Tue, 22 May 2007 16:30:15 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-221-217-243.bk12-dsl.surnet.cl [201.221.217.243]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l4MJUEVN021792; Tue, 22 May 2007 12:30:14 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 2767E32A14; Tue, 22 May 2007 15:30:10 -0400 (CLT) Date: Tue, 22 May 2007 15:30:10 -0400 From: Alvaro Herrera To: Chris Hoover Cc: "pgsql-admin@postgresql.org" Subject: Re: What happens on a commit? Message-ID: <20070522193010.GH11032@alvh.no-ip.org> References: <1d219a6f0705221025i1c1d036eq4769b133cac7499@mail.gmail.com> <1d219a6f0705221110v6718eaa1w67e17ac0c940772a@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1d219a6f0705221110v6718eaa1w67e17ac0c940772a@mail.gmail.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 22 May 2007 12:30:15 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/228 X-Sequence-Number: 25548 Chris Hoover escribió: > 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 This means that 60% of the time spent by system calls is due to network operations. But they account to 18.3 seconds, whereas this > real 27m21.090s > user 0m5.379s > sys 0m23.073s says that the total time spent is 27:21. So you have to explain the remaining 27:03 which are elsewhere. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.