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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux