Skip site navigation (1) Skip section navigation (2)

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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-28 21:03:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docspgsql-patches
Hash: SHA1

On Wed, 28 Nov 2007 12:57:10 -0800
David Fetter <david(at)fetter(dot)org> wrote:

> On Wed, Nov 28, 2007 at 03:53:04PM -0500, Tom Lane wrote:
> > David Fetter <david(at)fetter(dot)org> writes:
> > > Best practices for partitioning so far have shown that TRIGGERs
> > > are better than RULEs for most cases.  Please find attached a
> > > patch which reflects this.
> > 
> > Entirely removing the example of how to do it with rules doesn't
> > seem like a good idea.
> It does to me.  I haven't found a case yet where rules worked even as
> well as triggers.

I have yet to see a place that rules are appropriate at all with
partitioning. The only half reasonable argument to their existence with
it is that they are easier for someone with an extremely simple
partitioning configuration.

However rules are so deficient on anything except the absolute most
basic example of partitioning that I think we are doing our new
partitioning users a disservice by stating anything about rules except
in passing.


Joshua D. Drake

> Cheers,
> David.

- -- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997
Donate to the PostgreSQL Project:
PostgreSQL Replication:

Version: GnuPG v1.4.6 (GNU/Linux)


In response to

pgsql-docs by date

Next:From: Alvaro HerreraDate: 2007-11-28 21:40:36
Subject: Re: Two fixes for plpgsql.sgml
Previous:From: Bruce MomjianDate: 2007-11-28 20:57:28
Subject: Re: Two fixes for plpgsql.sgml

pgsql-patches by date

Next:From: Andrew DunstanDate: 2007-11-28 22:13:08
Subject: Re: [HACKERS] plperl and regexps with accented characters - incompatible?
Previous:From: David FetterDate: 2007-11-28 20:57:10
Subject: Re: Partition: use triggers instead of rules

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group