pgsql: Don't allocate storage for partitioned tables.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Don't allocate storage for partitioned tables.
Date: 2017-03-31 20:29:19
Message-ID: E1cu3Ad-0004sa-6v@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Don't allocate storage for partitioned tables.

Also, don't allow setting reloptions on them, since that would have no
effect given the lack of storage. The patch does this by introducing
a new reloption kind for which there are currently no reloptions -- we
might have some in the future -- so it adjusts parseRelOptions to
handle that case correctly.

Bumped catversion. System catalogs that contained reloptions for
partitioned tables are no longer valid; plus, there are now fewer
physical files on disk, which is not technically a catalog change but
still a good reason to re-initdb.

Amit Langote, reviewed by Maksim Milyutin and Kyotaro Horiguchi and
revised a bit by me.

Discussion: http://postgr.es/m/20170331.173326.212311140.horiguchi.kyotaro@lab.ntt.co.jp

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c94e6942cefe7d20c5feed856e27f672734b1e2b

Modified Files
--------------
doc/src/sgml/ref/create_table.sgml | 2 ++
src/backend/access/common/reloptions.c | 30 +++++++++++++++---------------
src/backend/catalog/heap.c | 20 ++++++++++++--------
src/include/access/reloptions.h | 3 ++-
src/include/catalog/catversion.h | 2 +-
5 files changed, 32 insertions(+), 25 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2017-03-31 20:52:46 pgsql: Revert "Allow ON CONFLICT .. DO NOTHING on a partitioned table."
Previous Message Robert Haas 2017-03-31 19:25:06 pgsql: postgres_fdw: Teach IMPORT FOREIGN SCHEMA about partitioning.