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

From Tim Smith
Subject Re: Delete rule does not prevent truncate
Date
Msg-id CA+HuS5Gjp6xLZ8fn8q8+08XdKAEXiNOBnjdPXAL6M5LCMHYkqw@mail.gmail.com
Whole thread Raw
In response to Re: Delete rule does not prevent truncate  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Delete rule does not prevent truncate  (Melvin Davidson <melvin6925@gmail.com>)
List 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 by date:

Previous
From: Tim Smith
Date:
Subject: Re: Delete rule does not prevent truncate
Next
From: JPLapham
Date:
Subject: Re: Using the database to validate data