Re: Delete rule does not prevent truncate - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Delete rule does not prevent truncate
Date
Msg-id CAOR=d=027aVejy0HcS+GwXi1Y=anRKFUM3Wnenak4oyAos2kRg@mail.gmail.com
Whole thread Raw
In response to Delete rule does not prevent truncate  (Tim Smith <randomdev4+postgres@gmail.com>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Delete rule does not prevent truncate
Next
From: Jeff Janes
Date:
Subject: Re: Using the database to validate data