Re: [DOCS] Partition: use triggers instead of rules - Mailing list pgsql-patches

From David Fetter
Subject Re: [DOCS] Partition: use triggers instead of rules
Date
Msg-id 20071128204120.GI24146@fetter.org
Whole thread Raw
In response to Re: [DOCS] Partition: use triggers instead of rules  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: [DOCS] Partition: use triggers instead of rules  (David Fetter <david@fetter.org>)
List pgsql-patches
On Wed, Nov 28, 2007 at 12:39:04PM -0800, Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Wed, 28 Nov 2007 12:26:15 -0800
> David Fetter <david@fetter.org> wrote:
>
> > Folks,
> >
> > 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.
> >
> > Thanks to Robert Treat for help putting this together :)
> >
> > Cheers,
> > David.
>
> +1
>
> Joshua D. Drake

Per Robert, I've also dropped the UNION partitioning suggestion as
it's pretty useless.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Attachment

pgsql-patches by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [DOCS] Partition: use triggers instead of rules
Next
From: David Fetter
Date:
Subject: Re: [DOCS] Partition: use triggers instead of rules