Re: TODO Request - Mailing list pgsql-hackers

Bruce Momjian wrote:
> 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 constraints for
>       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.

Thanks for this.

What about the other partioning types? And complicated should be what we 
are after :)

Sincerely,

Joshua D. Drake



> 
> ---------------------------------------------------------------------------
> 
> 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
> 


-- 
   === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240   Providing the most comprehensive  PostgreSQL
solutionssince 1997             http://www.commandprompt.com/