Locking vs. Exceptions

Поиск
Список
Период
Сортировка
От Robins
Тема Locking vs. Exceptions
Дата
Msg-id 36af4bed0611020445s445e3fe8o344f529190a8dfea@mail.gmail.com
обсуждение исходный текст
Ответы Re: Locking vs. Exceptions
Список pgsql-performance
Hi,

The documentation says that function blocks with exceptions are far costlier than without one.

So if I need to implement an INSTEAD OF trigger (after checking for unique constraint violations) which way should I go ?

1. Get a table lock
2. Use 'Select ... For Update' (which could be used to lock only the desired recordsets)
3. Use Exceptions

Any advice / experiences or even pointers would be helpful.

Thanks
Robins Tharakan

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs
Следующее
От: "Dave Dutcher"
Дата:
Сообщение: Re: Query plan for "heavy" SELECT with "lite" sub-SELECTs