Re: [PERFORM] Stored Procedure Performance

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема Re: [PERFORM] Stored Procedure Performance
Дата
Msg-id CAMjNa7fwCbh4YuwUY5D7W5bM90aqUEqw-goYAvAt3UFvT0kjqg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Stored Procedure Performance  (Purav Chovatia <puravc@gmail.com>)
Список pgsql-performance
> Yes, there is some code to catch exceptions like unique constraint violation and no data found. Do you suggest we
tryingby commenting that part?
 

That is likely it.  Comment that out and test.
If you still need to handle a unique violation, see if you can instead
use the ON CONFLICT clause on the INSERT.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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

Предыдущее
От: Purav Chovatia
Дата:
Сообщение: Re: [PERFORM] Stored Procedure Performance
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [PERFORM] Stored Procedure Performance