From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
---|---|
To: | "NikhilS" <nikkhils(at)gmail(dot)com> |
Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>, <pgsql-hackers(at)postgresql(dot)org>, "Markus Schiltknecht" <markus(at)bluegap(dot)ch> |
Subject: | Re: Auto Partitioning |
Date: | 2007-04-05 09:03:59 |
Message-ID: | 1175763839.3623.291.camel@silverbirch.site |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Thu, 2007-04-05 at 13:59 +0530, NikhilS wrote:
> Hi,
> > The only problem I have with this is that the shops I know
> with big
> > partitioned tables favor triggers over rules for both
> performance reason and
> > a cleaner implementation. Even with automated rule creation
> this isnt going
> > to change afaics... not to mention we already create our
> rules & triggers
> > automatically, so really this just isn't exciting to me
> (though it may make
> > it easier for people getting in on the ground floor)
>
> I second this. The trigger route is much more maintainable
> than the rule
> route. IMO what really needs to happen is something more low
> level where
> there are no DBA visible changes. Triggers also have overhead,
> it would
> be nice to get a little more bare metal with this.
>
> I had raised this issue about rules/triggers back then and the
> responses seemed to be evenly split as to which ones to use.
Presumably your implementation already uses Triggers for INSERTs though,
so why not use triggers for everything?
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-04-05 09:11:34 | Checkpoint gets stuck in mdsync |
Previous Message | Simon Riggs | 2007-04-05 09:00:20 | Re: Interaction of PITR backups andBulkoperationsavoiding WAL |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-04-05 09:34:50 | Re: [HACKERS] Full page writes improvement, code update |
Previous Message | NikhilS | 2007-04-05 08:29:35 | Re: Auto Partitioning |