H
Harshel Mike

Posted on 19th August 2022|21 views

0
votes

Postgresql Create Tablespace

How to create Tablespace in PostgreSQL?

Answers
P
naseer mohammad

Posted on 19th August 2022

One of the most efficient features in PostgreSQL as this feature allows the superuser to define or allocate a location to store the files holding the database objects.

Creating a tablespace Syntax:

CREATE TABLESPACE fastspace LOCATION '/mnt/sda1/postgresql/data'; 

The above syntax creates a tablespace which used to allocate files location which holds database objects.

By default, once we create a tablespace, then it creates two dataspaces:

Pg_global: it is used for shared systems when the database cluster initialised.

Pg_default: it creates default tablespace as template1, template0.

 

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos