From: Daulat Ram <Daulat.Ram@exponential.com>
To: amul sul <sulamul@gmail.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Cc: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: RE: Can we have multiple tablespaces with in a database.
Date: Fri, 21 Feb 2020 06:01:30 +0000
Message-ID: <MN2PR01MB5854F35E70DF08D6B5DD4ECA9B120@MN2PR01MB5854.prod.exchangelabs.com> (raw)
In-Reply-To: <CAAJ_b954ug=jYDvNUsnHj3j7yGt_p_nN31C7yDA8eafmOBcGOw@mail.gmail.com>
References: <MN2PR01MB585418CEA8E057268F18339A9B120@MN2PR01MB5854.prod.exchangelabs.com>
<CAAJ_b954ug=jYDvNUsnHj3j7yGt_p_nN31C7yDA8eafmOBcGOw@mail.gmail.com>
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@gmail.com>
Sent: Friday, February 21, 2020 11:16 AM
To: Daulat Ram <Daulat.Ram@exponential.com>
Cc: pgsql-general@lists.postgresql.org; pgsql-performance@lists.postgresql.org
Subject: Re: Can we have multiple tablespaces with in a database.
On Fri, Feb 21, 2020 at 11:04 AM Daulat Ram <Daulat.Ram@exponential.com<mailto:Daulat.Ram@exponential.com>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Daulat.Ram@exponential.com, sulamul@gmail.com, pgsql-general@lists.postgresql.org, pgsql-performance@lists.postgresql.org
Subject: RE: Can we have multiple tablespaces with in a database.
In-Reply-To: <MN2PR01MB5854F35E70DF08D6B5DD4ECA9B120@MN2PR01MB5854.prod.exchangelabs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox