Re: Delete rule does not prevent truncate

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Delete rule does not prevent truncate
Дата
Msg-id CAOR=d=027aVejy0HcS+GwXi1Y=anRKFUM3Wnenak4oyAos2kRg@mail.gmail.com
обсуждение исходный текст
Ответ на Delete rule does not prevent truncate  (Tim Smith <randomdev4+postgres@gmail.com>)
Список pgsql-general
On Fri, Jul 24, 2015 at 3:27 AM, Tim Smith <randomdev4@gmail.com> wrote:
> 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."

So, that's the sum total of what you took away from my post?
Nevermind, I'll leave you alone.


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

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