diff options
| author | Robert Haas | 2010-01-05 21:54:00 +0000 |
|---|---|---|
| committer | Robert Haas | 2010-01-05 21:54:00 +0000 |
| commit | d86d51a95810caebcea587498068ff32fe28293e (patch) | |
| tree | 031fb02a2ef325762250b163acd215cd7c31c2bb /src/test | |
| parent | 72559b49c051ff7dc860068c96324ddf07d7955d (diff) | |
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.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/input/tablespace.source | 6 | ||||
| -rw-r--r-- | src/test/regress/output/tablespace.source | 7 |
2 files changed, 13 insertions, 0 deletions
diff --git a/src/test/regress/input/tablespace.source b/src/test/regress/input/tablespace.source index df5479d5893..dba96f4547f 100644 --- a/src/test/regress/input/tablespace.source +++ b/src/test/regress/input/tablespace.source @@ -1,6 +1,12 @@ -- create a tablespace we can use CREATE TABLESPACE testspace LOCATION '@testtablespace@'; +-- try setting and resetting some properties for the new tablespace +ALTER TABLESPACE testspace SET (random_page_cost = 1.0); +ALTER TABLESPACE testspace SET (some_nonexistent_parameter = true); -- fail +ALTER TABLESPACE testspace RESET (random_page_cost = 2.0); -- fail +ALTER TABLESPACE testspace RESET (random_page_cost, seq_page_cost); -- ok + -- create a schema we can use CREATE SCHEMA testschema; diff --git a/src/test/regress/output/tablespace.source b/src/test/regress/output/tablespace.source index e57ad2b2174..79b12a86986 100644 --- a/src/test/regress/output/tablespace.source +++ b/src/test/regress/output/tablespace.source @@ -1,5 +1,12 @@ -- create a tablespace we can use CREATE TABLESPACE testspace LOCATION '@testtablespace@'; +-- try setting and resetting some properties for the new tablespace +ALTER TABLESPACE testspace SET (random_page_cost = 1.0); +ALTER TABLESPACE testspace SET (some_nonexistent_parameter = true); -- fail +ERROR: unrecognized parameter "some_nonexistent_parameter" +ALTER TABLESPACE testspace RESET (random_page_cost = 2.0); -- fail +ERROR: RESET must not include values for parameters +ALTER TABLESPACE testspace RESET (random_page_cost, seq_page_cost); -- ok -- create a schema we can use CREATE SCHEMA testschema; -- try a table |