Re: Slow UPADTE, compared to INSERT

Поиск
Список
Период
Сортировка
От Ivar Zarans
Тема Re: Slow UPADTE, compared to INSERT
Дата
Msg-id 20031205165253.GB30510@alcaron.ee
обсуждение исходный текст
Ответ на Re: Slow UPADTE, compared to INSERT  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Список 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 по дате отправления:

Предыдущее
От: Ivar Zarans
Дата:
Сообщение: Re: Slow UPADTE, compared to INSERT
Следующее
От: "Mike C. Fletcher"
Дата:
Сообщение: Re: Slow UPADTE, compared to INSERT