pgsql: Add CREATE TABLESPACE ... WITH ... Options

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add CREATE TABLESPACE ... WITH ... Options
Date: 2014-01-19 02:05:23
Message-ID: E1W4hlL-0003yW-Vm@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add CREATE TABLESPACE ... WITH ... Options

Tablespaces have a few options which can be set on them to give PG hints
as to how the tablespace behaves (perhaps it's faster for sequential
scans, or better able to handle random access, etc). These options were
only available through the ALTER TABLESPACE command.

This adds the ability to set these options at CREATE TABLESPACE time,
removing the need to do both a CREATE TABLESPACE and ALTER TABLESPACE to
get the correct options set on the tablespace.

Vik Fearing, reviewed by Michael Paquier.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/5254958e924cd54f33d37026d85483fef986060d

Modified Files
--------------
doc/src/sgml/ref/create_tablespace.sgml | 23 ++++++++++++++++++++++-
src/backend/commands/tablespace.c | 12 +++++++++++-
src/backend/nodes/copyfuncs.c | 1 +
src/backend/nodes/equalfuncs.c | 1 +
src/backend/parser/gram.y | 3 ++-
src/include/nodes/parsenodes.h | 1 +
src/test/regress/input/tablespace.source | 10 ++++++++++
src/test/regress/output/tablespace.source | 13 +++++++++++++
8 files changed, 61 insertions(+), 3 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Magnus Hagander 2014-01-19 12:27:52 pgsql: Adjust the SSL connection notification message
Previous Message Tom Lane 2014-01-19 00:25:45 pgsql: Fix VACUUM's reporting of dead-tuple counts to the stats collect