Tablespaces Wizard (PostgreSQL)

From DBArtisan
Jump to: navigation, search

Go Up to PostgreSQL Object Wizards

This wizard lets you build and submit a simple CREATE TABLESPACE statement, registering a new, cluster-wide tablespace.

To create a new tablespace using a wizard:

  1. Open a creation wizard for a tablespace. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Tablespaces (PostgreSQL) - Properties

When creating or editing a tablespace, this tab/panel lets you work with the following settings:

Setting Description

Table Schema and Table Name

Identify the table for which the constraint is being created.


Lets you type the name of the tablespace.


Lets you select the name of the user who will own the tablespace.


Lets you provide a LOCATION parameter clause, identifying the directory used for the tablespace.

random_page_code and seq_page_cost

When either of these settings are assigned values, the generated CREATE TABLESPACE DDL is followed by an ALTER TABLESPACE statement that lets you override the RANDOM_PAGE_COST and SEQ_PAGE_COST configuration parameters.