Re: Slow UPADTE, compared to INSERT

From: Ivar Zarans <iff(at)alcaron(dot)ee>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow UPADTE, compared to INSERT
Date: 2003-12-05 16:52:53
Message-ID: 20031205165253.GB30510@alcaron.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mike C. Fletcher 2003-12-05 17:05:45 Re: Slow UPADTE, compared to INSERT
Previous Message Ivar Zarans 2003-12-05 16:47:43 Re: Slow UPADTE, compared to INSERT