Re: Auto Partitioning Patch - WIP version 1
This is a discussion on Re: Auto Partitioning Patch - WIP version 1 within the Pgsql Patches forums, part of the PostgreSQL category; --> This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --------------------------------------------------------------------------- NikhilS wrote: > Hi, > > Please find attached ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-18-2008, 10:59 AM
| ||||
| ||||
 Re: Auto Partitioning Patch - WIP version 1 This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --------------------------------------------------------------------------- NikhilS wrote: > Hi, > > Please find attached the WIP version 1 of the auto partitioning patch. There > was discussion on this a while back on -hackers at: > http://archives.postgresql.org/pgsql...3/msg00375.php > > Please note that this patch tries to automate the activities that currently > are carried out manually. It does nothing fancy beyond that for now. There > were a lot of good suggestions, I have noted them down but for now I have > tried to stick to the initial goal of automating existing steps for > providing partitioning. > > Things that this patch does: > > i) Handle new syntax to provide partitioning: > > CREATE TABLE tabname ( > ... > ) PARTITION BY > RANGE(ColId) > | LIST(ColId) > ( > PARTITION partition_name CHECK(...), > PARTITION partition_name CHECK(...) > ... > ); > > ii) Create master table. > iii) Create children tables based on the number of partitions specified and > make them inherit from the master table. > > The following things are TODOs: > > iv) Auto generate rules using the checks mentioned for the partitions, to > handle INSERTs/DELETEs/UPDATEs to navigate them to the appropriate child. > Note that checks specified directly on the master table will get inherited > automatically. > v) Based on the PRIMARY, UNIQUE information specified, pass it on to the > children tables. > vi) [stretch goal] Support HASH partitions > > Will try to complete the above mentioned TODOs as soon as is possible. > > Comments, feedback appreciated. > > Thanks and Regards, > Nikhils > -- > > EnterpriseDB http://www.enterprisedb.com [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq      |
Linear Mode
