Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id A3ABB2E0174;
	Thu, 29 Nov 2007 12:02:40 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 72198-03-7; Thu, 29 Nov 2007 12:02:32 -0400 (AST)
Received: from lists.commandprompt.com (host-159.commandprompt.net
	[207.173.203.159])
	by postgresql.org (Postfix) with ESMTP id B31FC2E3ADE;
	Thu, 29 Nov 2007 12:01:39 -0400 (AST)
Received: from [192.168.1.4] (or-69-34-217-90.sta.embarqhsd.net
 [69.34.217.90])
	(authenticated bits=0)
	by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lATG1RD3000892
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Thu, 29 Nov 2007 08:01:28 -0800
Message-ID: <474EE25E.3080304@commandprompt.com>
Date: Thu, 29 Nov 2007 08:01:34 -0800
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Thunderbird 1.5.0.13 (Windows/20070809)
MIME-Version: 1.0
To: Michael Paesold <mpaesold@gmx.at>
CC: NikhilS <nikkhils@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	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: [PATCHES] Partition: use triggers instead of rules
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>
In-Reply-To: <474EDAE2.3010705@gmx.at>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0
	(lists.commandprompt.com [207.173.203.159]);
	Thu, 29 Nov 2007 08:01:28 -0800 (PST)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/124
X-Sequence-Number: 4657

Michael Paesold wrote:
> NikhilS wrote:

>> <note><para>If you have a partitioning setup that uses rules please 
>> refer to the 8.2 documentation on partitioning</para></note>
>>
>> +1
> 
> I would also add another sentence about *why* the recommendation was 
> changed. We have one rule-based setup here, and it has been working 
> flawlessly for us,... so personally I don't even know the reasons.
> 

Rules are extremely slow in comparisons and not anywhere near as 
flexible. As I said up post yesterday... they work well in the basic 
partitioning configuration but anything else they are extremely deficient.

Joshua D. Drake

> Best Regards
> Michael Paesold
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>