Documentation improvements for partitioning

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Documentation improvements for partitioning
Date: 2017-02-03 09:15:40
Message-ID: bf9ebbb3-fb1e-3206-b67c-e7a803a747d9@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Here are some patches to improve the documentation about partitioned tables:

0001: Adds some details about partition_bound_spec to the CREATE TABLE
page, especially:

- a note about inclusivity of range partition bounds,
- a note about the UNBOUNDED literal in case of range partitioning,
- a note about the NULL literal in case of list partitioning,

I wonder if the above "note" should be added under the Notes section or
are they fine to be added as part of the description of PARTITION OF
clause. Also:

- in syntax synopsis, it appears now that any expression is OK to be used
for individual bound datum, but it's not true. Only literals are
allowed. So fixed that.
- added an example showing how to create partitions of a range
partitioned table with multiple columns in the partition key
- added PARTITION BY and PARTITION OF (FOR VALUES) as PostgreSQL
extensions in the compatibility section

0002: Adds details about partitioned tables to the DDL chapter (ddl.sgml)

- a new section named "Partitioned Tables" right next to the
Inheritance and Partitioning sections is created.
- examples are added to the existing Partitioning section using the new
partitioned tables. Old text about implementing table partitioning
using inheritance is kept, sort of as a still supported older
alternative.

0003: Add partitioning keywords to keywords.sgml

This is all I have for now. Any feedback is greatly appreciated. Adding
this to the next CF.

Thanks,
Amit

Attachment Content-Type Size
0001-Improve-CREATE-TABLE-documentation-of-partitioning.patch text/x-diff 6.8 KB
0002-Update-ddl.sgml-for-declarative-partitioning.patch text/x-diff 23.5 KB
0003-Add-partitioning-keywords-to-keywords.sgml.patch text/x-diff 1.4 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavan Deolasee 2017-02-03 09:19:38 Re: Index corruption with CREATE INDEX CONCURRENTLY
Previous Message vinayak 2017-02-03 09:12:01 Postgres_fdw behaves oddly