OSDN Git Service

Support ALTER TABLESPACE name SET/RESET ( tablespace_options ).
authorRobert Haas <rhaas@postgresql.org>
Tue, 5 Jan 2010 21:54:00 +0000 (21:54 +0000)
committerRobert Haas <rhaas@postgresql.org>
Tue, 5 Jan 2010 21:54:00 +0000 (21:54 +0000)
commitd86d51a95810caebcea587498068ff32fe28293e
tree031fb02a2ef325762250b163acd215cd7c31c2bb
parent72559b49c051ff7dc860068c96324ddf07d7955d
Support ALTER TABLESPACE name SET/RESET ( tablespace_options ).

This patch only supports seq_page_cost and random_page_cost as parameters,
but it provides the infrastructure to scalably support many more.
In particular, we may want to add support for effective_io_concurrency,
but I'm leaving that as future work for now.

Thanks to Tom Lane for design help and Alvaro Herrera for the review.
28 files changed:
doc/src/sgml/config.sgml
doc/src/sgml/ref/alter_tablespace.sgml
src/backend/access/common/reloptions.c
src/backend/catalog/aclchk.c
src/backend/commands/tablespace.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/nodes/outfuncs.c
src/backend/optimizer/path/costsize.c
src/backend/optimizer/util/plancat.c
src/backend/parser/gram.y
src/backend/tcop/utility.c
src/backend/utils/adt/selfuncs.c
src/backend/utils/cache/Makefile
src/backend/utils/cache/spccache.c [new file with mode: 0644]
src/backend/utils/cache/syscache.c
src/bin/pg_dump/pg_dumpall.c
src/include/access/reloptions.h
src/include/catalog/catversion.h
src/include/catalog/pg_tablespace.h
src/include/commands/tablespace.h
src/include/nodes/nodes.h
src/include/nodes/parsenodes.h
src/include/nodes/relation.h
src/include/utils/spccache.h [new file with mode: 0644]
src/include/utils/syscache.h
src/test/regress/input/tablespace.source
src/test/regress/output/tablespace.source