From: David Fetter <david@fetter.org>
To: PostgreSQL Docs <pgsql-docs@postgresql.org>
Cc: PostgreSQL Patches <pgsql-patches@postgresql.org>
Subject: Re: Partition: use triggers instead of rules
Date: Wed, 28 Nov 2007 12:41:20 -0800
Message-ID: <20071128204120.GI24146@fetter.org> (raw)
In-Reply-To: <20071128123904.672beb8b@commandprompt.com>
References: <20071128202615.GG24146@fetter.org>
<20071128123904.672beb8b@commandprompt.com>
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/donateAttachments:partition.diff (text/plain, 1.1K) download
Index: doc/src/sgml/ddl.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ddl.sgml,v
retrieving revision 1.77
diff -c -r1.77 ddl.sgml
*** doc/src/sgml/ddl.sgml 28 Nov 2007 15:42:31 -0000 1.77
--- doc/src/sgml/ddl.sgml 28 Nov 2007 20:39:48 -0000
***************
*** 2571,2594 ****
script that generates the required DDL automatically.
</para>
- <para>- Partitioning can also be arranged using a <literal>UNION ALL</literal>- view:- - <programlisting>- CREATE VIEW measurement AS- SELECT * FROM measurement_y2004m02- UNION ALL SELECT * FROM measurement_y2004m03- ...- UNION ALL SELECT * FROM measurement_y2005m11- UNION ALL SELECT * FROM measurement_y2005m12- UNION ALL SELECT * FROM measurement_y2006m01;- </programlisting>- - However, the need to- recreate the view adds an extra step to adding and dropping- individual partitions of the data set.- </para>
</sect2>
<sect2 id="ddl-partitioning-managing-partitions">
--- 2571,2576 ----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: david@fetter.org, pgsql-patches@postgresql.org
Subject: Re: Partition: use triggers instead of rules
In-Reply-To: <20071128204120.GI24146@fetter.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox