Re: relational class vs partitioned table (was - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: relational class vs partitioned table (was
Date
Msg-id 1129035200.8300.465.camel@localhost.localdomain
Whole thread Raw
In response to relational class vs partitioned table (was Inherited indexes)  (Trent Shipley <tshipley@deru.com>)
List pgsql-hackers
On Mon, 2005-10-10 at 19:58 -0700, Trent Shipley wrote:
> Of course, there is no reason a relation in a relational class might not be 
> huge.  

Well, as a designer, I would make it so.

> Orthoganal partion rules would be created for the class.  The rules would be 
> applied to each member relation.  Finally, the rules would be applied to the 
> relevant unifying (presumably unique) indexes.
> 
> But inasmuch as Postgresql has implemented neither partitioning nor unique 
> constraints for relational classes we are getting somewhat ahead of 
> ourselves.

Maybe you aren't aware of the new constraint_exclusion feature in 8.1 ?

> Partitioning is obviously dominated by partitioning rules.  Oracle's SQL 
> dialect provides a negative example of how to elegantly incorporate 
> partitioning rules into SQL.  Ideally partitioning rules should be 
> first-class objects.  A database engineer or the poor DBA who inherits his 
> implementation should be able to query the meta-data to get a listing of all 
> partitioned relations.

The partitioning doesn't follow Oracle syntax at all. Partitions are
first class objects as you suggest.

Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: PG 8.1beta3 out soon
Next
From: "Ilia Kantor"
Date:
Subject: Re: Need A Suggestion