Support ALTER TABLESPACE name SET/RESET ( tablespace_options ).

Robert Haas <rhaas@postgresql.org>

Commit: d86d51a95810caebcea587498068ff32fe28293e

Author: Robert Haas <rhaas@postgresql.org>

Date: 2010-01-05T21:54:00Z

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.

Files

Path	Change	+/−
doc/src/sgml/config.sgml	modified	+10 −1
doc/src/sgml/ref/alter_tablespace.sgml	modified	+21 −1
src/backend/access/common/reloptions.c	modified	+49 −1
src/backend/catalog/aclchk.c	modified	+15 −46
src/backend/commands/tablespace.c	modified	+72 −1
src/backend/nodes/copyfuncs.c	modified	+16 −1
src/backend/nodes/equalfuncs.c	modified	+15 −1
src/backend/nodes/outfuncs.c	modified	+2 −1
src/backend/optimizer/path/costsize.c	modified	+48 −15
src/backend/optimizer/util/plancat.c	modified	+4 −1
src/backend/parser/gram.y	modified	+19 −1
src/backend/tcop/utility.c	modified	+14 −1
src/backend/utils/adt/selfuncs.c	modified	+17 −9
src/backend/utils/cache/Makefile	modified	+2 −2
src/backend/utils/cache/spccache.c	added	+183 −0
src/backend/utils/cache/syscache.c	modified	+14 −1
src/bin/pg_dump/pg_dumpall.c	modified	+18 −4
src/include/access/reloptions.h	modified	+6 −3
src/include/catalog/catversion.h	modified	+2 −2
src/include/catalog/pg_tablespace.h	modified	+6 −4
src/include/commands/tablespace.h	modified	+7 −1
src/include/nodes/nodes.h	modified	+2 −1
src/include/nodes/parsenodes.h	modified	+9 −1
src/include/nodes/relation.h	modified	+3 −1
src/include/utils/spccache.h	added	+19 −0
src/include/utils/syscache.h	modified	+2 −1
src/test/regress/input/tablespace.source	modified	+6 −0
src/test/regress/output/tablespace.source	modified	+7 −0