Re: [PATCHES] Partition: use triggers instead of rules

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Michael Paesold <mpaesold(at)gmx(dot)at>, NikhilS <nikkhils(at)gmail(dot)com>, David Fetter <david(at)fetter(dot)org>, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [PATCHES] Partition: use triggers instead of rules
Date: 2007-11-29 17:12:55
Message-ID: 15647.1196356375@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-patches

"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> Tom Lane wrote:
>> A trigger
>> will probably beat a rule for inserts/updates involving a small number
>> of rows.

> Which is exactly what partitioning is doing.

Nonsense. Well, maybe *you* never do that, but if so you are hardly
reflective of the whole world.

regards, tom lane

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Joshua D. Drake 2007-11-29 17:13:59 Re: Partition: use triggers instead of rules
Previous Message Gregory Stark 2007-11-29 17:08:29 Re: [DOCS] Partition: use triggers instead of rules

Browse pgsql-patches by date

  From Date Subject
Next Message Joshua D. Drake 2007-11-29 17:13:59 Re: Partition: use triggers instead of rules
Previous Message Gregory Stark 2007-11-29 17:08:29 Re: [DOCS] Partition: use triggers instead of rules