Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0C3E39FB1DC for ; Sat, 13 Jan 2007 23:08:57 -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 84909-08 for ; Sat, 13 Jan 2007 23:08:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (Postfix) with SMTP id 389109FB1E4 for ; Sat, 13 Jan 2007 23:08:45 -0400 (AST) Received: (qmail 5275 invoked from network); 14 Jan 2007 03:08:43 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.14?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 14 Jan 2007 03:08:43 -0000 In-Reply-To: <28391.1168734268@sss.pgh.pa.us> References: <45A96D70.90506@sun.com> <28391.1168734268@sss.pgh.pa.us> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <07997618-2474-4A53-A2C4-692909335A3B@fastcrypt.com> Cc: Jignesh Shah , pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: Performance of Parser? Date: Sat, 13 Jan 2007 22:08:57 -0500 To: Tom Lane X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/217 X-Sequence-Number: 22818 On 13-Jan-07, at 7:24 PM, Tom Lane wrote: > Jignesh Shah writes: >> The appserver is basically using bunch of prepared statements that >> the >> server should be executing directly without doing the parsing again. > > Better have another look at that theory, because you're clearly > spending > a lot of time in parsing (operator resolution to be specific). I > think > your client code is failing to re-use prepared statements the way you > think it is. This is exactly what is happening. The driver needs to cache statements for this to work. Dave > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that > your > message can get through to the mailing list cleanly >