CODEWITHSUNDEEP
postgresqlpostgresql-9.3
Viraj
Viraj

Reputation: 5381

How to add data file to PostgreSQL database tablespace?

I am using PostgreSQL and I want to add a new data files to existing tablespace ( like in oracle )

I could not found any description on this on PostgreSQL documentation. How to do this ?

Upvotes: 3

Views: 5377

Answers (1)

stefan.schwetschke
stefan.schwetschke

Reputation: 8932

PotgreSQL works different than Oracle. It has a much simpler concept for data storage. Data blocks, extents and segments don't exist. In the same spirit, a tablespace is not split into multiple data files. You just create the tablespace and PostgreSQL creates the necessary files to store the data.

When creating a tablespace, you can provide a location, where PostgreSQL should store the data:

CREATE TABLESPACE dbspace LOCATION '/data/dbs';

This works similar to bigfile tablespaces in Oracle, where you also don't have to manage data files.

Upvotes: 8

Related Questions