Re: Delete rule does not prevent truncate

Поиск
Список
Период
Сортировка
От Tim Smith
Тема Re: Delete rule does not prevent truncate
Дата
Msg-id CA+HuS5Gjp6xLZ8fn8q8+08XdKAEXiNOBnjdPXAL6M5LCMHYkqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Delete rule does not prevent truncate  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Delete rule does not prevent truncate  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
On 23 July 2015 at 19:25, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> stick to triggers, they're faster


Erm, not according to your beloved manual !!!

38.7. Rules Versus Triggers

" a rule issuing one extra command is likely to be faster than a trigger"
"The summary is, rules will only be significantly slower than triggers
if their actions result in large and badly qualified joins, a
situation where the planner fails."


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

Предыдущее
От: Tim Smith
Дата:
Сообщение: Re: Delete rule does not prevent truncate
Следующее
От: JPLapham
Дата:
Сообщение: Re: Using the database to validate data