Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id CEB8C9F938C for ; Wed, 3 Jan 2007 13:16:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 96465-04-3 for ; Wed, 3 Jan 2007 13:16:20 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from myemma.com (db1.e2ma.net [66.179.147.163]) by postgresql.org (Postfix) with ESMTP id AA4289FA5E2 for ; Wed, 3 Jan 2007 13:15:43 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by myemma.com (Postfix) with ESMTP id 2EECA23D06; Wed, 3 Jan 2007 11:15:43 -0600 (CST) Received: from myemma.com ([127.0.0.1]) by localhost (velma [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27234-09; Wed, 3 Jan 2007 11:15:41 -0600 (CST) Received: from [10.0.23.39] (unknown [209.149.59.218]) by myemma.com (Postfix) with ESMTP id 944C123CFD; Wed, 3 Jan 2007 11:15:41 -0600 (CST) Message-ID: <459BE4BB.4070601@myemma.com> Date: Wed, 03 Jan 2007 11:15:39 -0600 From: Erik Jones User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 To: Guillaume Smet Cc: Tom Lane , pgsql-performance@postgresql.org Subject: Re: More 8.2 client issues (Was: [Slow dump?) References: <459AD5A8.7030102@myemma.com> <22512.1167779361@sss.pgh.pa.us> <459BD61C.3030202@myemma.com> <11617.1167841479@sss.pgh.pa.us> <459BDC98.8030008@myemma.com> <1d4e0c10701030850h78f19e74hfa7c25c01ded9a61@mail.gmail.com> In-Reply-To: <1d4e0c10701030850h78f19e74hfa7c25c01ded9a61@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at myemma.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/39 X-Sequence-Number: 22640 Guillaume Smet wrote: > Erik, > > Could you set log_min_duration_statement=0 on your server and enable > logging (tutorial here if you don't know how to do that: > http://pgfouine.projects.postgresql.org/tutorial.html). > > You should see which queries are executed in both cases and find the > slow one easily. Heh, unfortunately, setting log_min_duration_statement=0 would be a total last resort as the last we counted (2 months ago) we were doing approximately 3 million transactions per hour. -- erik jones software development emma(r)