Rule vs Trigger

From: "Alfred Zhao" <rongkai(dot)zhao(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Rule vs Trigger
Date: 2007-06-19 13:09:13
Message-ID: 000901c7b273$0a8b8f50$0201a8c0@gemyard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Suppose I want to update a statistics table S after an insertion into an
activity table A. In order to update S automatically, I can either create a
rule on A or create an after trigger on A. What's the performance
implication on using rule vs trigger? Thanks in advance.

Alfred

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2007-06-19 13:15:22 Re: [pgsql-advocacy] [PERFORM] Postgres VS Oracle
Previous Message Geoffrey 2007-06-19 12:52:04 Re: [GENERAL] [PERFORM] Postgres VS Oracle