From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | NikhilS <nikkhils(at)gmail(dot)com>, "Markus Schiltknecht" <markus(at)bluegap(dot)ch>, simon(at)2ndquadrant(dot)com |
Subject: | Re: Auto Partitioning |
Date: | 2007-04-04 20:55:54 |
Message-ID: | 200704041655.55105.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Wednesday 04 April 2007 09:19, NikhilS wrote:
> Our current partitioning solution is based on inheritance. With that in
> mind, for 8.3 I thought an implementation based on auto rules creation
> would be the way to go.
>
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)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-04-04 20:59:38 | Re: Auto Partitioning |
Previous Message | Andrew Dunstan | 2007-04-04 20:52:16 | Re: build/install xml2 when configured with libxml |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-04-04 20:56:13 | Re: HOT WIP Patch - version 6.3 |
Previous Message | Andrew Dunstan | 2007-04-04 20:52:16 | Re: build/install xml2 when configured with libxml |