pgsql: Support unlogged tables.
От | Robert Haas |
---|---|
Тема | pgsql: Support unlogged tables. |
Дата | |
Msg-id | E1PXuX5-00082d-TT@gemulon.postgresql.org обсуждение исходный текст |
Ответы |
Re: pgsql: Support unlogged tables.
|
Список | pgsql-committers |
Support unlogged tables. The contents of an unlogged table are WAL-logged; thus, they are not available on standby servers and are truncated whenever the database system enters recovery. Indexes on unlogged tables are also unlogged. Unlogged GiST indexes are not currently supported. Branch ------ master Details ------- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=53dbc27c62d8e1b6c5253feba04a5094cb8fe046 Modified Files -------------- doc/src/sgml/catalogs.sgml | 3 +- doc/src/sgml/indexam.sgml | 11 + doc/src/sgml/ref/create_table.sgml | 21 ++- doc/src/sgml/ref/create_table_as.sgml | 12 +- doc/src/sgml/ref/pg_dump.sgml | 11 + doc/src/sgml/ref/pg_dumpall.sgml | 11 + doc/src/sgml/storage.sgml | 22 ++- src/backend/access/gin/gininsert.c | 42 ++++ src/backend/access/gist/gist.c | 13 + src/backend/access/hash/hash.c | 15 ++- src/backend/access/hash/hashovfl.c | 9 +- src/backend/access/hash/hashpage.c | 20 +- src/backend/access/nbtree/nbtree.c | 31 +++ src/backend/access/transam/xlog.c | 17 ++ src/backend/catalog/catalog.c | 14 +- src/backend/catalog/heap.c | 19 ++ src/backend/catalog/index.c | 11 + src/backend/catalog/storage.c | 49 +++-- src/backend/commands/tablecmds.c | 19 +- src/backend/parser/gram.y | 11 +- src/backend/storage/buffer/bufmgr.c | 53 +++-- src/backend/storage/file/Makefile | 2 +- src/backend/storage/file/copydir.c | 3 +- src/backend/storage/file/fd.c | 2 +- src/backend/storage/file/reinit.c | 396 +++++++++++++++++++++++++++++++++ src/backend/utils/adt/dbsize.c | 1 + src/backend/utils/cache/relcache.c | 2 + src/bin/pg_dump/pg_dump.c | 71 +++++- src/bin/pg_dump/pg_dump.h | 1 + src/bin/pg_dump/pg_dumpall.c | 7 + src/bin/psql/describe.c | 36 +++- src/include/access/gin.h | 1 + src/include/access/gist_private.h | 1 + src/include/access/hash.h | 9 +- src/include/access/nbtree.h | 1 + src/include/catalog/catalog.h | 2 +- src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_am.h | 18 +- src/include/catalog/pg_class.h | 1 + src/include/catalog/pg_proc.h | 8 + src/include/catalog/storage.h | 2 + src/include/parser/kwlist.h | 1 + src/include/pg_config_manual.h | 2 +- src/include/storage/buf_internals.h | 1 + src/include/storage/bufmgr.h | 6 +- src/include/storage/copydir.h | 1 + src/include/storage/reinit.h | 23 ++ src/include/storage/relfilenode.h | 5 +- src/include/utils/rel.h | 1 + 49 files changed, 916 insertions(+), 104 deletions(-)
В списке pgsql-committers по дате отправления:
Предыдущее
От: Robert HaasДата:
Сообщение: Re: pgsql: Ooops, no DATE_IS_NOBEGIN/DATE_IS_NOEND in 8.3 or 8.2 ...