X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 00838D1B445 for ; Fri, 5 Dec 2003 17:12:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 89407-03 for ; Fri, 5 Dec 2003 13:12:09 -0400 (AST) Received: from web01-imail.rogers.com (web01-imail.bloor.is.net.cable.rogers.com [66.185.86.75]) by svr1.postgresql.org (Postfix) with ESMTP id B8D6DD1B454 for ; Fri, 5 Dec 2003 13:12:08 -0400 (AST) Received: from rogers.com ([65.50.20.132]) by web01-imail.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20031205171225.ZBLS73768.web01-imail.rogers.com@rogers.com> for ; Fri, 5 Dec 2003 12:12:25 -0500 Message-ID: <3FD0BC67.5080300@rogers.com> Date: Fri, 05 Dec 2003 12:12:07 -0500 From: "Mike C. Fletcher" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20030925 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Slow UPADTE, compared to INSERT References: <20031204185751.GA15893@alcaron.ee> <20031205123843.GA27170@alcaron.ee> <3FD07EEA.8030007@persistent.co.in> <200312051323.43966.dev@archonet.com> <20031205164743.GA30510@alcaron.ee> In-Reply-To: <20031205164743.GA30510@alcaron.ee> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Authentication-Info: Submitted using SMTP AUTH PLAIN at web01-imail.rogers.com from [65.50.20.132] using ID at Fri, 5 Dec 2003 12:12:25 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/130 X-Sequence-Number: 4990 Ivar Zarans wrote: >On Fri, Dec 05, 2003 at 01:23:43PM +0000, Richard Huxton wrote: > > >>Better IMHO would be: "UPDATE table1 SET status = %s WHERE recid = %s::int8" >> >> > >Thanks for the hint! > > Which makes the wrapper class need: def __str__( self ): return "%s::int8"%(self.value,) Enjoy, Mike _______________________________________ Mike C. Fletcher Designer, VR Plumber, Coder http://members.rogers.com/mcfletch/