Re: [PATCHES] Partition: use triggers instead of rules - Mailing list pgsql-docs

From Joshua D. Drake
Subject Re: [PATCHES] Partition: use triggers instead of rules
Date
Msg-id 474EE25E.3080304@commandprompt.com
Whole thread Raw
In response to Partition: use triggers instead of rules  (David Fetter <david@fetter.org>)
Responses Re: [PATCHES] Partition: use triggers instead of rules
List pgsql-docs
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
>


pgsql-docs by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [PATCHES] Partition: use triggers instead of rules
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] Partition: use triggers instead of rules