| From: | Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Partitioning syntax |
| Date: | 2010-01-14 09:13:23 |
| Message-ID: | 20100114181323.9A33.52131E4D@oss.ntt.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Here is a revised partitioning syntax patch. It implements only syntax and
on-disk structure mentioned below:
Table Partitioning#Syntax
http://wiki.postgresql.org/wiki/Table_partitioning#Syntax
Table Partitioning#On-disk structure
http://wiki.postgresql.org/wiki/Table_partitioning#On-disk_structure
What we can do with the patch is src/test/regress/sql/partition.sql.
Note that the patch does nothing about INSERTs; triggers are still needed.
The main syntax is CREATE TABLE () PARTITION BY {RANGE | LIST} (...).
The reason I use it rather than "PARTITIONED BY" is for compatibility
to other DBMSs; Oracle and MySQL.
Changes from the previous CommitFest are:
- Additinal regression tests:
1000 partitions, error cases and boolean partitions
- Use pg_inherits_parent_index index if available.
- Sort not only range partitions but also list partitions
for stable display order.
- Remove ALTER PARTITION and DROP PARTITION syntax because
they are just synonyms of ALTER TABLE and DROP TABLE.
Regards,
---
Takahiro Itagaki
NTT Open Source Software Center
| Attachment | Content-Type | Size |
|---|---|---|
| partitioning-syntax_20100114.patch | application/octet-stream | 143.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KaiGai Kohei | 2010-01-14 09:22:35 | Re: [PATCH] remove redundant ownership checks |
| Previous Message | Fujii Masao | 2010-01-14 09:02:46 | Re: Streaming replication and non-blocking I/O |