| 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: | [email protected] |
| Views: | Whole Thread | Raw Message | 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 |