pgsql: Don't allocate storage for partitioned tables.

Поиск
Список
Период
Сортировка
От Robert Haas
Тема pgsql: Don't allocate storage for partitioned tables.
Дата
Msg-id E1cu3Ad-0004sa-6v@gemulon.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: pgsql: postgres_fdw: Teach IMPORT FOREIGN SCHEMA about partitioning.
Следующее
От: Robert Haas
Дата:
Сообщение: pgsql: Revert "Allow ON CONFLICT .. DO NOTHING on a partitionedtable."