Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A3AA39FB55F for ; Thu, 19 Jul 2007 14:05:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 18400-08 for ; Thu, 19 Jul 2007 14:05:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.239]) by postgresql.org (Postfix) with ESMTP id 9F7879FA26D for ; Thu, 19 Jul 2007 14:05:26 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id h29so551459wxd for ; Thu, 19 Jul 2007 10:05:25 -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:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Sz11LNYSRQ7GvzkxjQDADVsuwsv6EjXPFLUH9HUz/5P8Aah4qwFSVyFLl592Hhgdt6z+IMy4Tn6SSeU4Hth3bhpMNZO1aam+tlmk6X2jTtCKjkXkgDJAQs4m3rvRXQ1sPNyJScZnW/jUKZ3IPAMWhHb3jOugHMXcyMq0+mCJoYQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=UbRuIC0HN/qo4OJJ/oe0Fxvc742m54YNYDmHv8GcBZVLtt8ngB/MVUXWK2dcWa4f3x5Q8gbqLSwSWSA09m2nP2P+EgYYSZk+n3ZEbhYp9mZCGLS2I0IFk6lFRdQwftZSMf1wBLTn1uKAn4i5wZvpFD5wWAVPq6DBPCa+8wI/ncc= Received: by 10.90.49.1 with SMTP id w1mr3105833agw.1184864724927; Thu, 19 Jul 2007 10:05:24 -0700 (PDT) Received: by 10.70.41.4 with HTTP; Thu, 19 Jul 2007 10:05:24 -0700 (PDT) Message-ID: Date: Thu, 19 Jul 2007 19:05:24 +0200 From: "Claus Guttesen" To: arnaulist@andromeiberica.com Subject: Re: Is it possible to know where is the "deadlock" Cc: "PostgreSQL Performance" In-Reply-To: <469F9500.7060402@andromeiberica.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <469F9500.7060402@andromeiberica.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/244 X-Sequence-Number: 25928 > The iostat -c says about 8% of time waiting for IO. I'm afraid this > is due to locks between concurrent queries, is there anyway to have more > info about? I do believe that if you told what OS you're running, what pg-version you're running, what type of sql-statements you perform the list can provide some help. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare