RE: Can we have multiple tablespaces with in a database.

[Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx>]

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';

 

 

 

Can we have multiple tablespaces with in a database in postgres?

 

Yes.

 

 

 

From: amul sul <sulamul@xxxxxxxxx>
Sent: Friday, February 21, 2020 11:16 AM
To: Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx; pgsql-performance@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Can we have multiple tablespaces with in a database.

 

 

 

On Fri, Feb 21, 2020 at 11:04 AM Daulat Ram <Daulat.Ram@xxxxxxxxxxxxxxx> wrote:

Hi Team,

 

Can we have multiple tablespaces with in a database in postgres?

 

Yes.

 

Can we have a table on different tablespace same as Oracle?

Yes -- specify TABLESPACE option while creating that table.

 

Regards,

Amul