Обсуждение: pgsql: Don't allocate storage for partitioned tables.

Поиск
Список
Период
Сортировка

pgsql: Don't allocate storage for partitioned tables.

От
Robert Haas
Дата:
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(-)