36.1. Creating a Tablespace #
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to Tablespaces.
In the right-top corner of the page, click Create space.
Specify parameters of the new tablespace (parameters marked with an asterisk are required):
Instance: The instance to which the tablespace will be assigned.
Name.
Catalog: The path to the directory where the tablespace will be located.
Owner: The DBMS user who will own the tablespace.
seq_page_cost: The value of the
seq_page_costparameter that will be assigned to the tablespace.random_page_cost: The value of the
random_page_costparameter that will be assigned to the tablespace.effective_io_concurrency: The value of the
effective_io_concurrencyparameter that will be assigned to the tablespace.maintenance_io_concurrency:The value of the
maintenance_io_concurrencyparameter that will be assigned to the tablespace.сompression: The use of the Compressed File System.
Possible values:
zstd
lz4
pglz
zlib
This functionality is available only in the Postgres Pro Enterprise edition.
When creating a tablespace, a directory is created in the file system, and the tablespace is then created using the
CREATE TABLESPACEcommand. You can also create a tablespace in an existing directory, provided the directory is empty.Click Save.