Partitioning feature ...

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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


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


Attachment Content-Type Size
partition.patch application/octet-stream 143.2 KB
partition.sql application/octet-stream 6.2 KB


Browse pgsql-hackers by date

  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)