Re: Deprecating RULES

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Simon Riggs <simon(at)2ndQuadrant(dot)com>, Daniel Farina <daniel(at)heroku(dot)com>, darren(at)darrenduncan(dot)net, Peter Geoghegan <peter(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Deprecating RULES
Date: 2012-10-17 17:50:02
Message-ID: 507EEFCA.4070301@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 10/17/2012 01:02 PM, Joshua D. Drake wrote:
>
> On 10/17/2012 02:48 AM, Simon Riggs wrote:
>
>> Would you or someone else be able to come up with some words of
>> caution for us to put in the manual that would be helpful to
>> developers?
>>
>> There isn't even a list of caveats for rules.
>
> I think we need the inverse. Some documentation on why to use rules
> and this basically boils down to the problem. Can anyone tell me a
> reason to use explicit rules over a trigger and function combination?
>
>

I don't know how many times I have to say this: people are not
listening. Tom has already given a case for it upthread:

>> Triggers necessarily operate on a row-at-a-time basis. In theory,
>> for at least some bulk operations, a rule could greatly outperform
>> a trigger. It's difficult to walk away from that - unless somebody
>> can prove that the advantage doesn't ever accrue in practice.
>

People can keep ignoring that if they like, but some of us won't. This
mantra of "there is no reason at all to use rules" is like climate
change denial - no matter how many times you say it that won't make it true.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Nolan 2012-10-17 18:02:28 Re: Deprecating RULES
Previous Message Greg Stark 2012-10-17 17:46:00 Re: Deprecating RULES