Attach a tablespace to a hypertable and use it to store chunks. A [tablespace][postgres-tablespaces] is a directory on the filesystem that allows control over where individual tables and indexes are stored on the filesystem. A common use case is to create a tablespace for a particular storage disk, allowing tables to be stored there. Please review the standard PostgreSQL documentation for more [information on tablespaces][postgres-tablespaces].
TimescaleDB can manage a set of tablespaces for each hypertable, automatically spreading chunks across the set of tablespaces attached to a hypertable. If a hypertable is hash partitioned, TimescaleDB will try to place chunks that belong to the same partition in the same tablespace. Changing the set of tablespaces attached to a hypertable may also change the placement behavior. A hypertable with no attached tablespaces will have its chunks placed in the database's default tablespace.
|TEXT||Name of the tablespace to attach.|
|REGCLASS||Hypertable to attach the tablespace to.|
Tablespaces need to be [created][postgres-createtablespace] before
being attached to a hypertable. Once created, tablespaces can be
attached to multiple hypertables simultaneously to share the
underlying disk storage. Associating a regular table with a tablespace
TABLESPACE option to
CREATE TABLE, prior to calling
create_hypertable, will have the same effect as calling
attach_tablespace immediately following
|BOOLEAN||Set to true to avoid throwing an error if the tablespace is already attached to the table. A notice is issued instead. Defaults to false.|
Attach the tablespace
disk1 to the hypertable
SELECT attach_tablespace('disk1', 'conditions'); SELECT attach_tablespace('disk2', 'conditions', if_not_attached => true);
Found an issue on this page?Report an issue!