Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [PATCHES] Partition: use triggers instead of rules
- From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
- To: Michael Paesold <mpaesold(at)gmx(dot)at>
- Cc: NikhilS <nikkhils(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Fetter <david(at)fetter(dot)org>, "Jonah H. 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: Thu, 29 Nov 2007 08:01:34 -0800
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>+1I 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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
- Follow-Ups:
- Re: [PATCHES] Partition: use triggers instead of rules
- From: Tom Lane
- Re: [PATCHES] Partition: use triggers instead of rules
- References:
- Partition: use triggers instead of rules
- From: David Fetter
- Re: Partition: use triggers instead of rules
- From: Tom Lane
- Re: [PATCHES] Partition: use triggers instead of rules
- From: David Fetter
- Re: [PATCHES] Partition: use triggers instead of rules
- From: Tom Lane
- Re: [PATCHES] Partition: use triggers instead of rules
- From: Joshua D. Drake
- Partition: use triggers instead of rules
- Prev by Date: Re: [PATCHES] Partition: use triggers instead of rules
- Next by Date: Re: [PATCHES] Partition: use triggers instead of rules
- Previous by thread: Re: [PATCHES] Partition: use triggers instead of rules
- Next by thread: Re: [PATCHES] Partition: use triggers instead of rules
- Indexes: