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

Responses

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)