Re: [GENERAL] update slows down in pl/pgsql function

Поиск
Список
Период
Сортировка
От Jenny Zhang
Тема Re: [GENERAL] update slows down in pl/pgsql function
Дата
Msg-id 1071619646.10925.19.camel@ibm-a.pdx.osdl.net
обсуждение исходный текст
Ответ на Re: [GENERAL] update slows down in pl/pgsql function  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-performance
Oops, I named the var name the same as the column name.  Changing it to
something else solved the problem.

Thanks,
Jenny
On Tue, 2003-12-16 at 15:54, Stephan Szabo wrote:
> On Tue, 16 Dec 2003, Jenny Zhang wrote:
>
> > I have stored procedure written in pl/pgsql which takes about 13 seconds
> > to finish.  I was able to identify that the slowness is caused by one
> > update SQL:
> >
> > UPDATE shopping_cart SET sc_sub_total=sc_subtotal, sc_date=now()
> > WHERE sc_id=sc_id;
>
> Umm, is that exactly the condition you're using? Isn't that going to
> update the entire table?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match


В списке pgsql-performance по дате отправления:

Предыдущее
От: Richard Poole
Дата:
Сообщение: Re: Nested loop performance
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Optimizing FK & PK performance...