Re: Table Partitioning, Part 1 - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: Table Partitioning, Part 1
Date
Msg-id 20050510183215.GK31103@decibel.org
Whole thread Raw
In response to Re: Table Partitioning, Part 1  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Table Partitioning, Part 1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, May 10, 2005 at 12:16:17AM +0100, Simon Riggs wrote:
> On Mon, 2005-05-09 at 18:53 -0400, Tom Lane wrote:
> > Simon Riggs <simon@2ndquadrant.com> writes:
> > > 1. Embellish inheritance or separate infrastructure?
> > 
> > > It seems prudent to avoid building on that foundation, even though we
> > > may decide to use some similar approaches.
> > 
> > I disagree.  The code is there, it could use work, and what you are
> > basically proposing is to duplicate both the existing work and much
> > of the improvement it needs.
> 
> Minefields need clearing someday, I suppose. 
> 
> Multiple inheritance isn't something I'll be spending time on though.

I'm also not sure that inheritance would support all cases. For example,
in some situations PPUC3 leads to doing individual value partitioning,
where a partition is guaranteed to have only one value for part of the
PPK, meaning that there's no reason to store that part of the key in the
partition itself. Currently this is possible with partitions built out
of views but not out of inherited tables.
-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Views, views, views: Summary of Arguments
Next
From: Thomas Hallgren
Date:
Subject: Re: Oracle Style packages on postgres