Re: Slow UPADTE, compared to INSERT - Mailing list pgsql-performance

From Ivar Zarans
Subject Re: Slow UPADTE, compared to INSERT
Date
Msg-id 20031205165253.GB30510@alcaron.ee
Whole thread Raw
In response to Re: Slow UPADTE, compared to INSERT  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
List pgsql-performance
On Fri, Dec 05, 2003 at 07:21:38PM +0530, Shridhar Daithankar wrote:

> planner consider seemingly same type as different. e.g. treating int8 as
> different than int4. Obvious thinking is they should be same. But given
> postgresql's flexibility with create type, it is difficult to promote.

OK, this makes sense and explains a lot. Thanks!

> Well, then pypgsql should be upgraded to query the pg catalogd to find
> exact type of column. But that would be too cumbersome I guess.

Yes, so it seems. Time to rewrite my queries :)
Thanks again for help and explanations!

--
Ivar


pgsql-performance by date:

Previous
From: Ivar Zarans
Date:
Subject: Re: Slow UPADTE, compared to INSERT
Next
From: "Mike C. Fletcher"
Date:
Subject: Re: Slow UPADTE, compared to INSERT