Re: Slow UPADTE, compared to INSERT

From: "Mike C(dot) Fletcher" <mcfletch(at)rogers(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow UPADTE, compared to INSERT
Date: 2003-12-05 17:12:07
Message-ID: 3FD0BC67.5080300@rogers.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-12-05 17:26:05 Re: tuning questions
Previous Message Mike C. Fletcher 2003-12-05 17:05:45 Re: Slow UPADTE, compared to INSERT