pgsql: Don't allocate storage for partitioned tables. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Don't allocate storage for partitioned tables.
Date
Msg-id E1cu3Ad-0004sa-6v@gemulon.postgresql.org
Whole thread Raw
List 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(-)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: postgres_fdw: Teach IMPORT FOREIGN SCHEMA about partitioning.
Next
From: Robert Haas
Date:
Subject: pgsql: Revert "Allow ON CONFLICT .. DO NOTHING on a partitionedtable."