Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id F12D42E02BB;
	Thu, 29 Nov 2007 13:08:41 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 02802-04; Thu, 29 Nov 2007 13:08:37 -0400 (AST)
Received: from oxford.xeocode.com (unknown [62.232.55.118])
	by postgresql.org (Postfix) with ESMTP id DA4DE2E334A;
	Thu, 29 Nov 2007 13:08:36 -0400 (AST)
Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com)
	by oxford.xeocode.com with esmtp (Exim 4.67)
	(envelope-from <stark@enterprisedb.com>)
	id 1IxmsI-0001k0-2l; Thu, 29 Nov 2007 17:08:30 +0000
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>,  "Michael Paesold" <mpaesold@gmx.at>,
	"NikhilS" <nikkhils@gmail.com>,  "David Fetter" <david@fetter.org>,
	"Jonah H. Harris" <jonah.harris@gmail.com>,
	"PostgreSQL Docs" <pgsql-docs@postgresql.org>,
	"PostgreSQL Patches" <pgsql-patches@postgresql.org>
Subject: Re: [DOCS] Partition: use triggers instead of rules
In-Reply-To: <474EE992.2050209@commandprompt.com> (Joshua D. Drake's message
	of "Thu\, 29 Nov 2007 08\:32\:18 -0800")
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux)
X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.patches" 3236)
References: <20071128202615.GG24146@fetter.org>
	<21686.1196283184@sss.pgh.pa.us>
	<36e682920711281858x9a37039sa104036bf025de41@mail.gmail.com>
	<20071129031702.GU24146@fetter.org> <2854.1196315753@sss.pgh.pa.us>
	<20071128224154.06f950c9@commandprompt.com>
	<d3c4af540711290705q35ea51cdkfaa94b0c07a1aecc@mail.gmail.com>
	<474EDAE2.3010705@gmx.at> <474EE25E.3080304@commandprompt.com>
	<14455.1196353045@sss.pgh.pa.us> <474EE992.2050209@commandprompt.com>
From: Gregory Stark <stark@enterprisedb.com>
Organization: EnterpriseDB
Date: Thu, 29 Nov 2007 17:08:29 +0000
Message-ID: <87zlwxj7xu.fsf@oxford.xeocode.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/293
X-Sequence-Number: 4534


"Joshua D. Drake" <jd@commandprompt.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.

Say what?

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning