| From: | Kedar Potdar <kedar(dot)potdar(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Amit Gupta <amit(dot)pc(dot)gupta(at)gmail(dot)com> |
| Subject: | Partitioning feature ... |
| Date: | 2009-03-23 09:45:12 |
| Message-ID: | bd8134a40903230245j56e2be77tbec2fd4e25cf52f1@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
We are implementing table partitioning feature to support Range and Hash
partitions. Please find attached, the WIP patch and test-cases.
The syntax used conforms to most of the suggestions mentioned in
http://archives.postgresql.org/pgsql-hackers/2008-01/msg00413.php, barring
the following:
-- Specification of partition names is optional. System will be able to
generate partition names in such cases.
-- Sub partitioning
We are maintaining a system catalog(pg_partition) for partition meta-data.
System will look-up this table to find appropriate partition to operate on.
System internally uses low-level 'C' triggers to row-movement.
Regards,
--
Kedar.
| Attachment | Content-Type | Size |
|---|---|---|
| partition.patch | application/octet-stream | 143.2 KB |
| partition.sql | application/octet-stream | 6.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2009-03-23 11:34:31 | Re: contrib function naming, and upgrade issues |
| Previous Message | KaiGai Kohei | 2009-03-23 09:01:28 | [PATCH] SE-PostgreSQL for v8.5 development (r1769) |