Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: partition.sql
Description: application/octet-stream (6.2 KB)
Attachment: partition.patch
Description: application/octet-stream (143.2 KB)

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2009-03-23 11:34:31
Subject: Re: contrib function naming, and upgrade issues
Previous:From: KaiGai KoheiDate: 2009-03-23 09:01:28
Subject: [PATCH] SE-PostgreSQL for v8.5 development (r1769)

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group