Re: TODO Request - Mailing list pgsql-hackers

Added to TODO:
* Simplify ability to create partitioned tables
  This would allow creation of partitioned tables without requiring  creation of rules for INSERT/UPDATE/DELETE, and
constraintsfor  rapid partition selection.  Options could include range and hash  partition selection.
 
* Allow auto-selection of partitioned tables for min/max() operations

I didn't add subparitions because that seems pretty complicated.

---------------------------------------------------------------------------

Joshua D. Drake wrote:
> Tom Lane wrote:
> > "Joshua D. Drake" <jd@commandprompt.com> writes:
> >> Can we get:
> 
> Well this should be fun.
> 
> > 
> >> Multiple table indexes (for uniqueness across partitions for example)
> >> Auto creations of partitions
> 
> This would be something like:
> 
> create table foo () partition by ...
> 
> >> Hash partitioning
> 
> Partitioning by HASH is used primarily to ensure an even distribution of 
> data among a predetermined number of partitions.
> 
> >> Key partitioning
> 
> Partitioning by key is similar to partitioning by hash, except that 
> where hash partitioning employs a user-defined expression.
> 
> >> Sub partitioning
> > 
> 
> Subpartitioning ? also known as composite partitioning ? is the further 
> division of each partition in a partitioned table. (partitions that have 
> partitions)
> 
> 
> >> Added to the TODO list?
> > 
> > Perhaps a certain amount of specificity as to what these mean,
> > and why we need them, would be appropriate.
> 
> For reference I am directly apply my fair use rights to the above per 
> the MySQL development docs. Reference below:
> 
> http://dev.mysql.com/doc/refman/5.1/en/partitioning.html
> 
> Yes I am fully aware that we don't need to do something just because 
> MySQL does it. However, Oracle has similar functionality and I would 
> like to see us keep up :)
> 
> Of course I would like it to be done correctly :)
> 
> Sincerely,
> 
> Joshua D. Drake
> 
> 
> > 
> >             regards, tom lane
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> >        subscribe-nomail command to majordomo@postgresql.org so that your
> >        message can get through to the mailing list cleanly
> > 
> 
> 
> -- 
> 
>     === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
>     Providing the most comprehensive  PostgreSQL solutions since 1997
>               http://www.commandprompt.com/
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +