| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Tim Smith <randomdev4(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 14:25:09 |
| Message-ID: | CAOR=d=027aVejy0HcS+GwXi1Y=anRKFUM3Wnenak4oyAos2kRg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 24, 2015 at 3:27 AM, Tim Smith <randomdev4(at)gmail(dot)com> wrote:
> 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."
So, that's the sum total of what you took away from my post?
Nevermind, I'll leave you alone.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alejandro Taboada | 2015-07-24 14:30:55 | BDR Error on Debian wheezy packages |
| Previous Message | JPLapham | 2015-07-24 13:55:10 | Re: Using the database to validate data |