Re: Delete rule does not prevent truncate

From: Tim Smith <randomdev4(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Delete rule does not prevent truncate
Date: 2015-07-24 09:27:23
Message-ID: CA+HuS5Gjp6xLZ8fn8q8+08XdKAEXiNOBnjdPXAL6M5LCMHYkqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 23 July 2015 at 19:25, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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."

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Smith 2015-07-24 09:29:21 Re: Delete rule does not prevent truncate
Previous Message Tim Smith 2015-07-24 09:24:55 Re: Delete rule does not prevent truncate