Postgres Pro
Downloads
Home   >   mailing lists

Re: Can we have multiple tablespaces with in a database. - Mailing list pgsql-general

From amul sul
Subject Re: Can we have multiple tablespaces with in a database.
Date
Msg-id CAAJ_b97HSMVhDvgRQX4XF64k_ACfKKwkZpeaSVF_CjeuPCF9+A@mail.gmail.com
Whole thread Raw
In response to RE: Can we have multiple tablespaces with in a database.  (Daulat Ram <Daulat.Ram@exponential.com>)
Responses RE: Can we have multiple tablespaces with in a database.
RE: Can we have multiple tablespaces with in a database.
RE: Can we have multiple tablespaces with in a database.
RE: Can we have multiple tablespaces with in a database.
List pgsql-general
Tree view


On Fri, Feb 21, 2020 at 11:31 AM Daulat Ram <Daulat.Ram@exponential.com> wrote:

Hi Amul ,

Please share the examples how we can create no. of tablespaces for a single database and how we can use them.

As I know we can create database on tablespace

  1. CREATE TABLESPACE conn_tbs OWNER enterprisedb LOCATION '/mnt/pgdatatest/test/pgdata/conn_tbs';
  2. Create database test tablespace ‘conn_tbs';
Maybe I have misunderstood your question; there is no option to specify more
than one tablespace for the database, but you can place the objects of that
database to different tablespaces (if options available for that object).
E.g. you can place a table in than conn_tbs tablespace.

If option is not specified then by default that object will be created
in conn_tbs.

Regards,
Amul



pgsql-general by date:

Previous
From: Daulat Ram
Date:
Subject: RE: Can we have multiple tablespaces with in a database.
Next
From: Daulat Ram
Date:
Subject: RE: Can we have multiple tablespaces with in a database.